Format Cell

C

cmlm

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

Thanks in advance.:confused
 
J

JudithJubilee

Hello cmlm,

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

Judith
 
R

Ron Rosenfeld

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:
Click to expand...

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
 
Top