Excel date format behaves differently depending on PC

%3CLINGO-SUB%20id%3D%22lingo-sub-3013829%22%20slang%3D%22en-US%22%3EExcel%20date%20format%20behaves%20differently%20depending%20on%20PC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013829%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERecently%20I%20have%20created%20a%20simple%20macro%20to%20import%20XML%20data%20into%20excel%20worksheet.%20It%20works%20great%20but%20not%20on%20every%20computer.%20Basically%2C%20I%20import%20XML%20data%20as%20text%2C%20then%20ocassionally%20excel%20recognizes%20date%20format%20in%20cells%20but%20sometimes%20it%20doesn't.%20When%20I%20subtract%20one%20date%20from%20another%20on%20certain%20PC's%20I%20get%20proper%20time%20values%2C%20but%20sometimes%20I%20get%20error%20%22%23Value%22).%20I%20menaged%20to%20test%20the%20macro%20using%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B-%20Two%20workstation%20PC's%20Win%2010%20Pro-%26nbsp%3B(Macro%20is%20working%20properly%20only%20on%20one%20PC)%20(I'm%2099%25%20sure%20that%20both%20workstations%20are%20identical%20in%20terms%20of%20software%20)%3C%2FP%3E%3CP%3E-%20My%20personal%20Win%2010%20Pro%20Laptop%20-%26nbsp%3B(Macro%20is%20working%20properly)%3C%2FP%3E%3CP%3E-%20My%20personal%20Win%2010%20Edu%20PC%20-%20(Macro%20is%20working%20properly)%3C%2FP%3E%3CP%3E%26nbsp%3B-%20My%20friends%20Win%2010%20Pro%20laptop%20-%26nbsp%3B(Macro%20is%20not%20working%20properly)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20computers%2Flaptops%20are%20using%20Office%20365.%3C%2FP%3E%3CP%3EWhat%20setting%2Fissue%20may%20cause%20this%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3013829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3013886%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20date%20format%20behaves%20differently%20depending%20on%20PC%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013886%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1232268%22%20target%3D%22_blank%22%3E%40SkullCrasher%3C%2FA%3E%26nbsp%3BI%20suspect%20that%20your%20friend%20has%20different%20regional%20settings.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fchange-the-windows-regional-settings-to-modify-the-appearance-of-some-data-types-edf41006-f6e2-4360-bc1b-30e9e8a54989%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fchange-the-windows-regional-settings-to-modify-the-appearance-of-some-data-types-edf41006-f6e2-4360-bc1b-30e9e8a54989%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

Recently I have created a simple macro to import XML data into excel worksheet. It works great but not on every computer. Basically, I import XML data as text, then ocassionally excel recognizes date format in cells but sometimes it doesn't. When I subtract one date from another on certain PC's I get proper time values, but sometimes I get error "#Value"). I menaged to test the macro using:

 

 - Two workstation PC's Win 10 Pro- (Macro is working properly only on one PC) (I'm 99% sure that both workstations are identical in terms of software )

- My personal Win 10 Pro Laptop - (Macro is working properly)

- My personal Win 10 Edu PC - (Macro is working properly)

 - My friends Win 10 Pro laptop - (Macro is not working properly)

 

All computers/laptops are using Office 365.

What setting/issue may cause this problem?

 

Thanks in advance!

1 Reply