Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Attempted edit of protected cell jumps user to another cell | Excel Discussion (Misc queries) | |||
Disable cell reference insertion with PageUp in cell edit mode. | Excel Discussion (Misc queries) | |||
How do I edit a cell in Excel without clicking on the cell first? | Excel Worksheet Functions | |||
Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel |