Date Auto Format

[Katie]

Hello. Until today, I have always used an excel auto
format that seems to have stopped. Prior to today, if I
selected a cell and formatted it as a date, I could then
type 0826 and hit tab, Excel would then auto format the
cell to read 08/26/04. Today, if I type 0826, the auto
format changes it to 04/05/02. Please help. Thank you.

 

[JE McGimpsey]

No version of XL natively turns an entry like 0826 into a true date like
08/26/04 even with autoformat. XL's converting the number to a date, in
which 04/05/1902 is 826 days after the base date of 31 December 1899.

You can format cells to display the number 826 to as 08/26/04 by using

Format/Cells/Number/Custom 00\/00\/\04

but the value will still be 826, and you'll have to change the format
for dates from other years.

If you previously were able to enter 0826 and have the entry converted
to a true date, you must have been running an event macro.

Take a look here for one technique:

http://cpearson.com/excel/DateTimeEntry.htm

 

[Katie]

Okay, thank you.

-----Original Message-----
No version of XL natively turns an entry like 0826 into a true date like
08/26/04 even with autoformat. XL's converting the number to a date, in
which 04/05/1902 is 826 days after the base date of 31 December 1899.

You can format cells to display the number 826 to as 08/26/04 by using

Format/Cells/Number/Custom 00\/00\/\04

but the value will still be 826, and you'll have to change the format
for dates from other years.

If you previously were able to enter 0826 and have the entry converted
to a true date, you must have been running an event macro.

Take a look here for one technique:

http://cpearson.com/excel/DateTimeEntry.htm




.