Formatting

[Soth]

Hi -

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

Any help is appreciated.

Soth

 

[Shane Devenshire]

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.

 

[Luke M]

Change format of cell to 'Number', with 0 decimals. Make sure column is wide
enough, or cell will display ####.

 

[David Biddulph]

But that number has only 15 significant figures, so Excel copes with it
quite happily. Just format as number with zero decimal places. We might
ask whether the OP is really confident in the number to that precision, but
we won't.