how can I enter 453. to show as 453 instead of 4.53 when using th.

G

Guest

I'm not sure how to use the decimal when entering numbers in excel. I want
to use the fixed decimal space as to so when I just type in 453 it appears as
4.53 But when I want to enter 60 and I enter 60. I get .60

Any thoughts?
 

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

How to set "fixed decimal" in 2007 4
in excel how do i get 1.23 when i enter 123 5
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. 3
In Excel how do I get 2 zeros to show automatically after I enter. 7
I can't figure out how to hold chart references firm when inserting data 2
How to break apart a Decimal formatted number? 2
How to show repeating decimals line 1
Custom Format - Show 12.5 but not 12.0 (drop .0s) ? 2

Top