| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to date format
Hi everyone, In our system generated .CSV file, one column is the date in the format of YYYYMMDD, for example 20060301. I want to format this column to this date format, 3/1/2006, but I can't. It just gives me a bunch of #'s. I copied the column to another sheet but got the same result. -- ledzepe ------------------------------------------------------------------------ ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207 View this thread: http://www.excelforum.com/showthread...hreadid=517978 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Date format not correct when you convert a CSV text file in Excel | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| MS Query Date Format | Excel Discussion (Misc queries) | |||
| Date format within a text syntex? | Excel Worksheet Functions | |||
Threaded Mode
