Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date format error in cell
I have one cell that for some reason even though the format is set to
general, when i put in say 2007-2011 i get a pop up box that says date format error. the issue is that this is the only cell in the entire column with this issue. this is a file exported out of SAP to Excel with VBA code in the background. then we insert two columns next to a date column. so the new columns are picking up that format. what i don't understand is why when i change the format the top cell still doesn't work. any ideas? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date format error in cell
On Mar 23, 11:07*am, pat67 wrote:
I have one cell that for some reason even though the format is set to general, when i put in say 2007-2011 i get a pop up box that says date format error. the issue is that this is the only cell in the entire column with this issue. this is a file exported out of SAP to Excel with VBA code in the background. then we insert two columns next to a date column. so the new columns are picking up that format. what i don't understand is why when i change the format the top cell still doesn't work. any ideas? I have it figured out. for some reason, the data validation for only the top cell in the column i am inserting next to was set to a date. i removed it and now it's fine. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date format error | Excel Discussion (Misc queries) | |||
Date-error Format | Setting up and Configuration of Excel | |||
Date format error in Excel | Excel Worksheet Functions | |||
How do I fix a date format error in Excel? | Excel Discussion (Misc queries) | |||
Date Format - April error | Excel Discussion (Misc queries) |