Simple date entry WAY off

[ulineteks]

Entering today's date as "013006" in a blank cell/new workbook, an
changing formatting to ANY type, returns crazy date of "8/10/1935"?

All PCs across our company appear to be doing this "all of sudden."
Date/regional settings are all normal still. Only recent change was a
update to ASAP Utilities, but I can't see how that would affect thing
since it's just a plugin.

Thoughts/suggestions?

Thanks

 

[Anne Troy]

I do believe a plugin or macro would be required to have the proper date
appear when no symbols are typed anyway, so perhaps you lost that previous
plugin or macro as a result of installing ASAP.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Pete_UK]

Excel will treat the number as 13006 by removing the leading zero. If
you then format it to date it will show 10th August 1935, as that is
the number of elapsed days since 1st Jan 1900. If you enter the date as
"1/30" (without the quotes), then Excel should interpret it correctly
for the current year.

Hope this helps.

Pete

 

[Ron Rosenfeld]

Entering today's date as "013006" in a blank cell/new workbook, and
changing formatting to ANY type, returns crazy date of "8/10/1935"?

All PCs across our company appear to be doing this "all of sudden."
Date/regional settings are all normal still. Only recent change was an
update to ASAP Utilities, but I can't see how that would affect things
since it's just a plugin.

Thoughts/suggestions?

Thanks.

Possibly in the update to ASAP utilities, a required macro to convert your data
entry format into a "normal" Excel date was disabled.

It is not possible, without a macro (or a formula in an adjacent cell), to type
'013006' into a cell and have Excel understand that it represents 30 Jan 2006.


--ron