convert date format

  • Thread starter Thread starter fgwiii
  • Start date Start date
F

fgwiii

hello

I need to convert dates that are formatted as 10-Mar-2008 to 03/10/08. I
tried to just select a new format for the cells, but that did not work. I
tried to run calc now, but no luck. If I double click on each cell it will
convert, but I have several thousand cells to do.

Thanks

Fred
 
Sounds like you do not have real dates, just text
If the date is in cell A1 what does =ISNUMBER(A1) return? If should be TRUE.
It will return FALSE if you have text and we need to now more to help you.
How is a one digit date shown? 05-Sep-2008? Are all months three characters?

You could try Data | Text to Columns which has a facility to do some date
translations

best wishes
 
Try this.......
Type a 1 in an unused cell.
Click on the cell and do COPY
Highlight your "dates" and do PasteSpecial > Multiply
Reformat the cells to give the date as you wish to see it.

hth
Vaya con Dios,
Chuck, CABGx3
 
Hi Fred,
Suggest you install the code for reenter at
http://www.mvps.org/dmcritchie/excel/join.htm#reenter

If not familiar with macro use directions to install at
http://www.mvps.org/dmcritchie/excel/getstarted.htm#havemacro

To use select the afflicted area then run the macro (Alt+F8)
Please test on a copy of your worksheet, to avoid potential usage problems.

If you have not installed Excel 2007 (lucky you), you can install it
easily into a toolbar button or a menu -- would suggest as a menu
within reformat menu group.
http://www.mvps.org/dmcritchie/excel/toolbars.htm
http://www.mvps.org/dmcritchie/excel/toolbars.htm#menus
The following has an outline of how I have my menus (does not include reenter macro)
ttp://www.mvps.org/dmcritchie/excel/barhopper.htm
 
I would suggest that you format the area exactly as you want it first.
It would be better to use add of an empty cell, to avoid
problems with trying to convert an empty cell with multiplication.
 
Back
Top