Excel 2008 Number Format Issues


E

Evandavies75

I am having a problem with how numbers appear in cells after I enter
them. I am using Excel 2008 on my 15" MacBook Pro that's running OS X
10.5.1.

The problem is that when I enter a number it appears in the cell as
divided by 100 so I get it in decimal format. For example, I enter
the amount 3654 what appears in the cell is 3654. I have learned to
compensate by adding 00 to each number (365400 gets me the 3654 I
want).

Very frustrating.
 
Ad

Advertisements

B

Bob Greenblatt

I am having a problem with how numbers appear in cells after I enter
them. I am using Excel 2008 on my 15" MacBook Pro that's running OS X
10.5.1.

The problem is that when I enter a number it appears in the cell as
divided by 100 so I get it in decimal format. For example, I enter
the amount 3654 what appears in the cell is 3654. I have learned to
compensate by adding 00 to each number (365400 gets me the 3654 I
want).

Very frustrating.
Go to the edit tab in Excel's preferences and uncheck "Show this many
decimal places."
 

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

Top