View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
wt.pm wt.pm is offline
external usenet poster
 
Posts: 6
Default enter numbers without decimal places

Thank you Jim, I should have known that, but never would have thought about
it.

"Jim Thomlinson" wrote:

So when you enter a number it automatically has decimals included. Assuming
that to be the case check

Tools - Options - Edit | Fixed Decimal | Uncheck
--
HTH...

Jim Thomlinson


"wt.pm" wrote:

I am try to enter a inventory list, with a three digit ID number, so it will
look as follows:

543 $12.99
544 $22.99

But what I get is .543, 5.4 .005, .5 etc....

How do I get it to display 543 not showing a decimal. (I know that
technically it is 543.0, but you know what I mean)