Keeping date in lower case format

Giganews Newsgroups
Subject: Keeping date in lower case format
Posted by:  Mandy Phillips (philli…@edgehill.ac.uk)
Date: Wed, 22 Oct 2003

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.

Replies