View Single Post
  #1   Report Post  
Frustrated
 
Posts: n/a
Default Customized Date Format

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!