When entering whole numbers in Column F, which is formatted as Catogary
"General", it displays as a decimal number. How do I correct this?

Thanks in advance.


--
cmlm
------------------------------------------------------------------------
cmlm's Profile: http://www.excelforum.com/member.php...fo&userid=9018
View this thread: http://www.excelforum.com/showthread...hreadid=528891

Hello cmlm,

Try Tools + Options + Edit tab. Uncheck the Fixed Decimal box.

Judith
--
Hope this helps


"cmlm" wrote:


When entering whole numbers in Column F, which is formatted as Catogary
"General", it displays as a decimal number. How do I correct this?

Thanks in advance.


--
cmlm
------------------------------------------------------------------------
cmlm's Profile: http://www.excelforum.com/member.php...fo&userid=9018
View this thread: http://www.excelforum.com/showthread...hreadid=528891

On Sat, 1 Apr 2006 12:59:20 -0600, cmlm
wrote:


When entering whole numbers in Column F, which is formatted as Catogary
"General", it displays as a decimal number. How do I correct this?

Thanks in advance.

Is the number being displayed the same as the number you are entering, or is it
being divided by some power of 10?

If the latter, then Tools/Options/Edit and DEselect Fixed Decimal


--ron