Hi Praveen,
Your are using right function i.e, UPPER, but before that you should have
the data ready, which you want to convert in UPPER Case. So first use TEXT
function to take out the text from the date and then use UPPER function.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BC
Thanks a lot Harmeet. It worked.
On Sun, Oct 11, 2009 at 2:28 PM, Harmeet Singh wrote:
> *Enter date in cell "A1" then **Use formula-
> =UPPER(TEXT(A1,"dd-mmm-"))**I hope this will solve the issue.*
>
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On
Hi,
Use this formula.
=UPPER(TEXT(C20,"dd mmm "))
Regards
Sandeep
- Original Message -
From: "Praveen Khunte"
To: "MS EXCEL AND VBA MACROS"
Sent: Sunday, October 11, 2009 7:37 AM
Subject: $$Excel-Macros$$ Converting Date to uppercase
I have a requirement where date needs to be
*Enter date in cell "A1" then **Use formula-
=UPPER(TEXT(A1,"dd-mmm-"))**I hope this will solve the issue.*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sun, Oct 11, 2009 at 7:37 AM, Praveen Khunte wrote:
>
> I have a requirement where date needs to be in u
