This project has moved and is read-only. For the latest updates, please go here.

DateTime entered in GMT

Apr 10, 2011 at 2: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 ?

Apr 11, 2011 at 6:21 AM

I think the only way to accomplish that is by using a UDF like this:

Apr 11, 2011 at 7:16 AM

Thanks, this might work.