Reformatting Data Links

[liamrobertsSP]

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]

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."