Date and time

  • Thread starter Thread starter SRAlviggi in EPPS
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date / Time problem 4
Date and Time formatting 1
Excel Excel due and overdue date colours 2
Extracting time (hr:min) from date/time format 2
Excel Help with dates 2
single cell time entry as time - time; Ever seen this? 12
Unable to display date correctly######dates and times are negative 3
Copnvert dates reading as Text to a date format 5

Back
Top