Forum Discussion
Convert displayed date to mm/yyyy format, and convert that to text
I am attempting to shorten my keystroke times for data entry of several hundred dates. First, I need to convert the number format of six digits (ex: 072012) or five digits (ex: 72012) to display mm/...
Thank you, Hans.
Now, would I use that macro in Excel prior to the import, or is it used afterwards in Access?
This is a macro to be run in Excel.
- I'll try it out. thank you