Entering data

B

booklady

I cannot enter the data the way I want. For example, I want to enter the
number 280000 and it will enter 2800.00. I have tried putting the number in
as General, but I still get the fixed decimal. I have tried to enter it as a
number with 0 decimal places, but I still get the fixed decimal or it will
round off. What do I need to do?
 
K

Ken Johnson

I cannot enter the data the way I want. For example, I want to enter the
number 280000 and it will enter 2800.00. I have tried putting the number in
as General, but I still get the fixed decimal. I have tried to enter it as a
number with 0 decimal places, but I still get the fixed decimal or it will
round off. What do I need to do?
Click to expand...

Go Tools|Options then go to the Edit tab of the Options dialog and
deselect the Fixed decimal places option

Ken Johnson
 

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

fixed decimal formatting 2
How to set "fixed decimal" in 2007 4
decimal point override does not work 4
Fixed Decimals in Excel 2007 4
Using 1000 sperator without specifying decimal places 14
Fixed decimal places in Excel 4
Sum of numbers with only two decimal places wrong 2
Help with fixed decimal 4

Top