Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in date format
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in date format
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in date format
Convert? Do you mean to physically change it, within the same cell, to a
real date? You could use a helper column and put this formula... =--TEXT(A1,"0000-00-00") adjacent to the top cell with your 8-digit numbers in them (adjust the A1 to match the actual cell address) and copy it down. Then select the entries in the helper column and Edit/Copy them, select the top cell with your 8-digit number in it and click Edit/PasteSpecial, select Values and hit Okay, then delete the values in the helper column. Rick "mzaman1952" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in date format
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help in date format
What happened when you tried it?
Are you sure that column A contained just those 8 numeric characters? =len(a1) would help prove it. You may want to try it again. It's worked for lots of people. 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 -- Dave Peterson |
#6
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) |