Disappearing Decimals

R

randi

Whenever I type in $344.28, the only thing that shows up on the spreadsheet is $344. How do I get it to show all the decimals?
 
N

Niek Otten

Use a new, "clean worksheet", or format the cells as General before entering the data.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Whenever I type in $344.28, the only thing that shows up on the spreadsheet is $344. How do I get it to show all the decimals?
 

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 to count the numbers in a Word document? 0
Mail Merge - displaying a conditional number of decimals 5
Paste options button disappears 0
Using project as a resource tracker 0
Images disappear 0
Amending meeting cancels all future meetings 0
Mis-performing MP4 files in Mac PPT 1

Top