| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format issue
It is a text format like '20040415, not a number.
Thanks -----Original Message----- Is that a date or a number? If it is a date, just change the format (FormatCells). -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Meme" wrote in message ... Hi, I have a problem about date format transfering . For example, one column containing the date data in the format like "20040415" , now I want to change it to the format like "04/15/2004". As always,thanks so much in advance. Meme . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help....Date Format issue | Excel Discussion (Misc queries) | |||
| Date format issue | New Users to Excel | |||
| DATE FORMAT issue | Excel Worksheet Functions | |||
| Date format issue | Excel Worksheet Functions | |||
| Another Date Format issue | Excel Programming | |||
Hybrid Mode
