View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default excel puts dates instead of numbers when typed

Perhaps the cell has been pre-formatted as a date. Select the cell
again and click Format | Cells | Number (tab) and change the format to
General, or Number with 0 decimal places.

Hope this helps.

Pete

autumn wrote:
I am using Excel inventory. sometimes when I try to put a number in a slot
instead of the number such as 1 it puts 1-jan. no matter how I put the number
in it keeps changing it to a calender date.