Thread: Format Numbers
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Format Numbers

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?
--
David Biddulph

"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