Keeping date in lower case format

  • Thread starter Thread starter Mandy Phillips
  • Start date Start date
M

Mandy Phillips

Hi,

I need to import some data from Oracle that is in ddmmmyy
format i.e. 29jan73

The J in jan is lower case in oracle, but when i bring it
to excel it formats it to uppercase (29Jan73)

Is there any way I can stop this from happening, as I'd
like it all to be in lower case?

Thanks,

Mandy.
 
Hi Mandy,

You CAN change it by going to Tools | Options | Custom Lists, and then edit
Jan to jan.

But then it will be changed for everything.

Best regards,
Kevin
 
I use xl2002 and when I tried to change the custom list, xl wouldn't let me.
Since it was a built-in list, it looked like it was off-limits to changing.
 
The closest I could do was to use a helper column and use a formula like:
=LOWER(TEXT(A1,"ddmmmyy"))
 
Dave,

You are absolutely correct (same applies to XL 2000). Thank you for
correcting my error and providing a better answer to Mandy.

Regards,
Kevin
 
Back
Top