View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default enter numbers without decimal places

Format the cells to 'General'
--
If this post helps click Yes
---------------
Jacob Skaria


"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)