Number Format in Excel

G

Guest

When I type a nymber, it gets converted to that number divided by 100. For
example if I type 100 in the cell, it gets converted to 1.00. How do we set
it right?
 
C

Carim

Hi Mary,

In the menu Format Cells Number
and make your selection with the number of decimals needed ...

HTH
Cheers
Carim
 
B

Bob Phillips

Goto Tools>Options and on the Edit tab there is a checkbox for Fixed
Decimal. Uncheck that box.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 

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 Change Numbers to Text. ie $1.00 = one dollar 2
Excel Convert word into numbers and back 4
LISTNUM formatting 1
I am trying to use the IF and SUMIF function on Excel 8
Percentage Calculations Help 3
Excel Write a formula in excel where 1 = .05, 2 = .75, 3 = .30 etc. 4
Keyboard Formatting of a Cell 3
How do I set up 0 value or 1 in access 1

Top