Reformatting Data Links

liamrobertsSP · ‎04-08-2024

I have linked data from an excel sheet which has all worked well but unfortunately the Date links across as mm/dd/yyyy and I would like it in dd/mm/yyyy format. It is in the dd/mm/yyyy format in the excel document but not AutoCAD?

maxim_k · ‎04-08-2024

Hi @liamrobertsSP ,

If I use these settings for datalink when I insert it to a drawing:

I get correct results:

Please pay attention to the note in the "Format cells" dialog in Excel about date formats with *.

If you select such date formats (with *) in Excel, they "respond to changes in regional date and time settings that are specified for the operating system."

Do you find the posts helpful? "LIKE" these posts!
Have your question been answered successfully? Click 'ACCEPT SOLUTION' button.

Maxim Kanaev
Architect
MARSS

MacACAD | Linkedin

Etiquette and Ground Rules of Autodesk Community