Thread: Formatting
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Formatting

Hi,

Excel only supports numbers to 15 decimal places so if you want to see the
entry as you show it here you will need to preformat the cell to text or to
type an aprostrophy in front of it.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Soth" wrote:


Hi -

I can't seem to format this general number 2.23232E+16 to 22323173420061900.

Any help is appreciated.

Soth