Reading formatted strings

Feb 4, 2014 at 10:42 AM

is it possible to read not the cell value but the actual cell formatted string as seen by the user when he saved the file?

I'm dealing with a file where a column must be a datetime in ISO8601 format. Some users use it as a string, but others use it as a Excel datetime (double) but the use a custom formatting to display it with the correct timezone.

If I parse it from the double I lose the timezone information that the user actually "inserted" using the custom formatting...

How can I handle this?
Feb 5, 2014 at 10:12 AM
So your problem really is that you no longer know what timezone the user entered because the date ends up as UTC?

Feb 5, 2014 at 11:34 AM
Hi Ian,

I found out that in Excel you can format a datetime cell (double) in ISO8601 but you can't add the timezone value (es. +02:00) to the format string. So magically my problem is solved.

Thanks anyway.
Feb 5, 2014 at 11:49 AM
Ok. good