View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ms Veco Indiana Ms Veco Indiana is offline
external usenet poster
 
Posts: 2
Default Input a number to not display as a date

hello! I have ran into this problem a few times when I'm trying to get a
number to appear, i.e. 3-30, and it automatically changes it into a date,
30-Mar.

I've gone in and formatted and reformated the cell as a general number and
it automatically changes back to date....errrrrrrrr.