Format Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi!

I would like to know how can I format a number with more than 20 caracters
to display it on cell. When I paste the value it shows like
"8.955050340000140000000000000000E+19"

Does someone know how to do it?
 
Hi,

Maximum digits is 15 so to display a larger number Put a ' in front of the
number.

Mike
 
Hi Filipe

Either pre-format the cell as Text or use a single quote in front of the
number when entering
'12345678901234567890
 
I don't understand the question. The same as any other cell with a number,
you can format it as General, or as Number (with a defined number of decimal
places), or as Scientific, or as a Percentage, or as Currency, or as ...
What formatting are you trying to achieve, and what problem are you having
when you do so?
 
Back
Top