Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have set up a customized date format in Excel that works with a txt file.
However, if the date is only the year, i.e. 1955, without a day or month, it is interpreting the year as an unrelated date, i.e. 19 May 1905. The format is customized to read the abbreviated month as the full word for the month, but I can see I need to customize the format to accommodate just the year entries as well. Can this be done by a special format that will accommodate both types of date entries? Any help would be appreciated, and thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Help - Date Format | Excel Worksheet Functions | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) |