Thread: Format Numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Format Numbers

Hi,

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

Mike

"Filipe" wrote:

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