- Joined
- Jan 11, 2010
- Messages
- 1
- Reaction score
- 0
Excel 2007, Vista Business SP2 in case it makes a difference to my question.
I have Regional/Language Options Short Date set to "dd MMM yyyy" (9 Jan 2010) and Long Date set to "dddd, MMMM dd, yyyy" (Saturday, January 09, 2010).
In the header of my spreadsheet, I have "Printed &[Date]".
My question is, why does the header print "Printed 09 01 2010" instead of "Printed 9 Jan 2010"? How do I fix it?
I haven't been able to find anyplace to set it. In Excel Options, I've gone through everything several times and don't see where to change it so that it uses the computer's settings. There must be someplace, because when formatting a cell to use short date, and type "26 jan 10" it comes out "26 01 2010" and if I format a cell to use long date and type "26 jan 10", it comes out correctly as "Tuesday, January 26, 2010". So it's honoring the computer long date but not the computer short date.
Though I'm pretty decent in QuattroPro, I'm a novice at Excel. So I need step-by-step instructions on fixing this.
I have Regional/Language Options Short Date set to "dd MMM yyyy" (9 Jan 2010) and Long Date set to "dddd, MMMM dd, yyyy" (Saturday, January 09, 2010).
In the header of my spreadsheet, I have "Printed &[Date]".
My question is, why does the header print "Printed 09 01 2010" instead of "Printed 9 Jan 2010"? How do I fix it?
I haven't been able to find anyplace to set it. In Excel Options, I've gone through everything several times and don't see where to change it so that it uses the computer's settings. There must be someplace, because when formatting a cell to use short date, and type "26 jan 10" it comes out "26 01 2010" and if I format a cell to use long date and type "26 jan 10", it comes out correctly as "Tuesday, January 26, 2010". So it's honoring the computer long date but not the computer short date.
Though I'm pretty decent in QuattroPro, I'm a novice at Excel. So I need step-by-step instructions on fixing this.