| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in date format
It's working. Thank you so much!
"mzaman1952" wrote: It's not working. This date column (more than 8,000 dates) are in text format as for example : Column A Column B Column C 20080428 20080531 20080423 ........... and so on Column B to Column F are dollar and other Text. Since I want to reconcile the spreadsheet by month I need to change Column A to date format. If you can pl help me. Thanks. mzaman1952 "Dave Peterson" wrote: If you have a single column of these "dates", you can select that column. Data|Text to columns fixed width (but remove any lines excel guesses) choose Date (YMD) and finish the wizard Then format the cells the way you like. mzaman1952 wrote: In my spreadsheet I have date like "20080428" which I want to convert to 04/28/08 or any regular date. Can I able to do it? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Hybrid Mode
