Number Formatting

S

Susan

What would cause a worksheet suddenly change the number
formats? The number is typed as 55 and it appears as 5.5,
no matter what formatting you use. It will even do this
on blank worksheets. It had not done this before. Need
help. Might have to redo the whole file.
 
G

Gord Dibben

The entries you have already made will not change.

Enter 10 in an an unused cell. Copy. Select range of cells and Paste
Special>Multiply>OK>Esc. Clear the 10 from the cell.

Gord Dibben XL2002
 

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Outlook 365 overriding formatting choices 0
How to change font & size of (all) citation numbers? 7
Printing Outline view - formatting lost 0
Finding the proper style field and the numbered paragraph value within the style 0
New computer, how do i move outlook 365 ENTIRELY? 0
Microsoft word: fields are nested too deeply 1

Top