excel formatting dates

[NoCalAdmin]

I am working with Excel 2010 and am trying to get some dates that reside in a column to display with the date and time including GMT.

Is this done within conditional formatting or Styles? Having a issue figuring this one out

Any assistance would be great

Tom

Tom

 

[SkipVought]

Hi,

Date/Time is a NUMBER that is formatted to display in any number of various formats. The format is a DISPLAY feature, but the underlying value is a NUMBER.




Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[webrabbit]

Select the column, clck on FORMAT, CELLS, DATE&TIME, select the format you want or build a CUSTOM format.