Date Format

[maximpinto]

Hi,
In the excel date format, i got the date in the following format in excel.
Thursday, October 01, 2009

But i want to show it like 01-October-2009, Thursday.

How can i do this
Thanks
maxim

[Bob Phillips]

Give it a custome format of

dd-mmmm-yyyy, dddd

[maximpinto]

Dear,
Thanks a lot.
But i did not understand what you wrote down..:bug:
Max

[EirikDaude]

What you use is something like the following, where date is your date-variable:


Format(date, "dd-mmmm-yyyy, dddd")

[Bob Phillips]

Select the cell

Menu Format>Cells>Custom

Enter the text I gave.

[maximpinto]

Thanks i had understood that dear
what i had not understood was

"
Nihil simul inventum est et perfectum

Abusus non tollit usum"
How do i say a thread solved here in this forum, please guide
thanks
max

[Bob Phillips]

That is my signature, they are Latin phrases.


Nihil simul inventum est et perfectum - nothing is simultaneously invented and perfected

Abusus non tollit usum - abuse does not preclude use