View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Trouble formatting date

Clarification:
.. If this happens, we'd need to re-format the
cells as general, then it'll be sensed.


For new entry of dates, that is. For existing entries, we'd need to
re-confirm the entry (eg click inside the formula bar, press ENTER) before
it'd work. Merely reformatting the cells would not "fire" the sensing.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---