Thread: Format Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default 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.


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