Formatting

S

Soth

Hi -

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

Any help is appreciated.

Soth
 
S

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.
 
L

Luke M

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help 2
Document Merge Formatting Issue 0
numbering cells 3
Word Margins - Frustration 0
help with formula 2
Sorting and filtering text 0
Found few bugs in my daily routine of work in excel for MAC 0
Columns appearing from nowhere, formatting going weird 0

Top