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 ?

Apr 11, 2011 at 5:21 AM

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

Apr 11, 2011 at 6:16 AM

Thanks, this might work.