formatting cell numbers

  • Thread starter Thread starter DRKENNE
  • Start date Start date
D

DRKENNE

I've tried everything I can think of and still can't get a cell to hold a
whole number. I've tried the format number with no decimal, using general
number, and custom. Yet it all returns less than whole numbers. Any ideas?
Could a setting in MS Money cause this problem?
 
I've tried everything I can think of and still can't get a cell to hold a
whole number. I've tried the format number with no decimal, using general
number, and custom. Yet it all returns less than whole numbers. Any ideas?
Could a setting in MS Money cause this problem?
Click to expand...

I assume, even though you mention MS Money, that you are using Excel.

In XL2007, press the Office Button in the upper left corner, then select Excel
Options. From the Left menu select Advanced and deselect the option to
automatically insert a decimal point (under Editing options).

In pre-2007, if I recall correctly, that is reached by selecting
Tools/Options/Editing
--ron
 
Thanks. That took care of hte issue.


Ron Rosenfeld said:
I assume, even though you mention MS Money, that you are using Excel.

In XL2007, press the Office Button in the upper left corner, then select Excel
Options. From the Left menu select Advanced and deselect the option to
automatically insert a decimal point (under Editing options).

In pre-2007, if I recall correctly, that is reached by selecting
Tools/Options/Editing
--ron
Click to expand...
 
Back
Top