Date and time

S

SRAlviggi in EPPS

I want to change the way the date and time appears in a spreadsheet. I am
now geeting military time and a y/m/day format. I want to show the time in
a 12Hr. format and the date as Jan. 30, 2008. Itried to cange it in the
control panel but it did not chage when I placed the formula in the
spreadsheet. Ii looked ok in the dialog box in the control panel but in the
sheet it came up incorrect.
 
G

Gord Dibben

Excel uses the Regional settings of short date for its default date format.

You cannot change short date to Jan. 30, 2008

Excel's default time format is taken from Regional settings Time format.

You can change that setting to hh:mm:ss

In Excel you can format after the fact just about anyway you want.

Format>Cells>Number>Date

Choose a format from there or go to Format>Cells>Number>Custom and build your
own


Gord Dibben MS Excel MVP


On Wed, 30 Jan 2008 12:52:00 -0800, SRAlviggi in EPPS <SRAlviggi in
 
Top