Format Cell
 

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.:confused:


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

Format Cell
 

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.:confused:


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

Format Cell
 

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.:confused:

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