Formatting
 

Hi -

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

Any help is appreciated.

Soth

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

Formatting
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Soth" wrote:


Hi -

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

Any help is appreciated.

Soth

Formatting
 

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. :-)
--
David Biddulph

"Shane Devenshire" wrote in
message ...
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