excel formating

  • Thread starter Thread starter amber
  • Start date Start date
Hi,

Simply change the format.

Format|Cells
Select Time and the format you want

In Excel time is a number (.5 is 12 midday) and you simply format the same
number to how you want it to appear but the underlying value doesn't change.

Mike
 
From the top menu...
Format>Cells>Time
Select your favorite time format.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown
 
Back
Top