Thread: Cell Edit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim[_29_] Tim[_29_] is offline
external usenet poster
 
Posts: 8
Default Cell Edit

Hello All,

I have a program that exports files into Excel format.
The problem is that the date is formatted as a number, I
cannot change the format through "Format Cells". The
only way to get Excel to recognize this as a date is to
edit (F2) each cell or click in the formula bar and hit
enter.

Any help with this would be appreciated as I sometimes
have thousands of rows with dates.

Thanks in advance.