This project has moved. For the latest updates, please go here.

DateTime entered in GMT

Apr 10, 2011 at 1:41 PM

Is there a way to instrucs Excel that DateTime in given Cell in in GMT and it (Excel) should automatically convert it to current system locale ?

Coordinator
Apr 11, 2011 at 5:21 AM

I think the only way to accomplish that is by using a UDF like this: http://excel.tips.net/T002185_Automatically_Converting_to_GMT.html

Apr 11, 2011 at 6:16 AM

Thanks, this might work.