Thread: Format Numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Format Numbers

Hi Filipe

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

--
Regards
Roger Govier



"Filipe" wrote in message
...
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?

--
Filipe