changing date format
I have a similar question...how can you set a new Custom date in the cell
format application?
--
Thanks, Kathy
"Gord Dibben" wrote:
That won't "convert" the dates, just display them differently.
The underlying value will still be 09/20/08 or September 20, 2008
Do you need them actually "converted" to a text value of 080920 ?
="0"&(YEAR(A1)-2000)*10000+MONTH(A1)*100+DAY(A1)
Gord Dibben MS Excel MVP
On Mon, 21 Jan 2008 11:51:02 -0800, Julie
wrote:
Wow - easy - but I hadn't figured it out. Thank-you so much - you saved me
a ton of time!!!
|