Format Numbers

F

Filipe

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?
 
M

Mike H

Hi,

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

Mike
 
R

Roger Govier

Hi Filipe

Either pre-format the cell as Text or use a single quote in front of the
number when entering
'12345678901234567890
 
D

David Biddulph

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?
 
Top