View Single Post
  #1   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

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)