View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Jhawk Jhawk is offline
external usenet poster
 
Posts: 2
Default How do I stop decimal being placed in a 3 digit whole number

On a new spread sheet, every time I try to type a 3 digit whole number or
less (i.e. 2 digits) the cell records the number with a decimal placed after
the first number. How do I get the cell formated to accept whole numbers.
If I chekc the , between numbers and the number I use in 4 digits or longer I
do not have the problem. I have tried removing the decimal to 0.