View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Haider Haider is offline
external usenet poster
 
Posts: 1
Default Cell that is formated for Date shows a diffrent number

I have an Excel form with a Cell that you need to input sale date that I
input my self. The cell changes from example (12/1/2009) to 32453, but once
you double click on the cell it show the hidden (12/1/2009) once you click
out of it, it revets to the 32453 number. I check the cell format and it
show as date.