I can help with part of this - don't know if it will give u the end solution
you want, though...
I can help u get from m/d/yyyy to yyyymmdd.
You say you already have a cell with "m/d/yyyy h:mm". Select that cell;
press Ctrl+1 to access the Format dialogue box for that cell. Select the
tab number. in the category box, select "custom". Then, in the "type" box,
type "yyyymmdd" - just that. that will automatically change your m/d/yyyy
to yyyymmdd. You can also copy this format to any other cell in that
workbook to get from m/d/yyyy to yyyymmdd.
I don't understand what you mean when you write that you want to get from
the "h:mm" part to "text". What text exactly? It is possible to have Excel
just lose the h:mm in the cell so that you go from m/d/yyyy h:mm to plain
old yyyymmdd - but what's this text u want to add?
Hope this is of some help,
"Jeff" <com> wrote in message