General discussion

Locked

Excel date format inconsistencies

By Choppit ·
I frequently need to convert columns of dates in Excel formatted as dd.mm.yyyy to dd/mm/yy. If I perform a simple replace '.'with '/' all is well and the date formats are correct, however if I record a macro to do this the resulting formats are mixed (i.e. some are dd/mm/yy and some are mm/dd/yy). My question is twofold;

1) Why does this happen?
2) How can I stop this happening?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by mhartmann In reply to Excel date format inconsi ...

had a simluar problem with a customer ....what we did? Installed Office SP3 - works just fine ;-)!

Collapse -

by Choppit In reply to

Sorry, I forgot to mention that SP3 and all subsequent updates are applied. Thanks anyway.

Collapse -

by Choppit In reply to Excel date format inconsi ...

Version is Excel 2000 (O2K Premium) + SP3 + all subsequent updates from Office update site

Collapse -

by Choppit In reply to Excel date format inconsi ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums