If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Changing the Date Format
I have a spreadsheet that has a column of dates in the format yyyymmdd, and i
need to change them to mmddyy format, but when i use the usual right click/ format cells/ date, or if i go to the tool bars at the top of the page under format/ cells/ date, nothing happens, and the date format remains the same. Is there any way to get the date into the right format? Do i need a special, custom equation to do this? -- Amanda |
#2
|
|||
|
|||
Hi
It's because they are probably strings. Were they numbers, after formatting you'd got ######### in cell. You can use date formats with dates, like "yyyy-mm-dd", or "dd.mm.yyyy", or "dd. mmmm yyyy" etc. Dates in Excel are counted from 1. January 1900. P.e. todays date (08.09.2004) is really an integer 38238, and this real value doesn't change with formatting. To your problem - you have to use a formula in helper column. P.e. with date in A2: =MID(A2,5,2) & RIGHT(A2,2) & MID(A2,3,2) -- Arvi Laanemets (When sending e-mail, use address arvilAttarkon.ee) "xtian_princess" wrote in message ... I have a spreadsheet that has a column of dates in the format yyyymmdd, and i need to change them to mmddyy format, but when i use the usual right click/ format cells/ date, or if i go to the tool bars at the top of the page under format/ cells/ date, nothing happens, and the date format remains the same. Is there any way to get the date into the right format? Do i need a special, custom equation to do this? -- Amanda |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
QDE (Quick Date Entry) | Norman Harker | Worksheet Functions | 37 | September 5th, 2004 01:24 AM |
Changing Date format in Inbox 'Recieved' tab | Geoff Harding | General Discussion | 1 | June 3rd, 2004 08:30 PM |
Formatting dates in Excel | bernrunner15 | New Users | 4 | May 11th, 2004 10:32 PM |
Converting month in text format to date format | Peo Sjoblom | Worksheet Functions | 1 | April 26th, 2004 07:58 PM |
Pivot Table - Format of Date Field | Michelle | Worksheet Functions | 1 | February 3rd, 2004 07:56 PM |