formatting cell numbers

[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?

 

[Ron Rosenfeld]

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 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

 

[DRKENNE]

Thanks. That took care of hte issue.

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

 

[Ron Rosenfeld]

Thanks. That took care of hte issue.

You're welcome. Glad to help.
--ron