| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert date format
i am using microsoft office 2003.
currently i need to columns of data (in general format) to date (DD/MM/YY) format. tried clicking Format=Cells=Number=Date (select date type) it doesnt work. please advise alternate method thanks. regards noel |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
convert date format
On Sun, 26 Mar 2006 14:44:41 -0800, noel
wrote: date is now in mm/dd/yy (general format) after switching cell format to dd/mm/yy (date format) the same still Your "date" is really TEXT. Formatting will not change the appearance of text. Excel stores dates as serial numbers starting with 1 Jan 1900 (or 1904). Let's gather more information to decide how to fix this. How many dates are we talking about? How did the date information get into the cell? Will this be a repetitive task? --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Date Format | Excel Discussion (Misc queries) | |||
| Date Format Squirrelly | Excel Discussion (Misc queries) | |||
| Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| Date Format Question | Excel Discussion (Misc queries) | |||
Linear Mode
