Rick
I get data from all over - the records(rows) are date/time stamped from a process (production) - so when I report back my findings - I want to lock in the date/time stamp to what ever time zone the data was collected in. So regardless of what part of the world the sheet is viewed - the date/time stamp is locked and displayed as it was at the site where the data was originally collected. I hope this makes sense. Currently I add a ' in front of the date/time and then format it as a text field - But that way I have to use a format of YYYYMMDD hh:mm:ss - otherwise I cannot sort the date by time.
I hope this makes it clear what I am trying to do. So In a perfect worl I want the date/time to be displayed in using the time zone where it was collected - but formatted to the PC that is opening the sheet. I.e. the Europeans use military time and not AM/PM