A
ACarella
How do I format a date
05/30/07 into
Wednesday, May 30, 2007
05/30/07 into
Wednesday, May 30, 2007
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duke Carey
Select the cell
press Ctrl-1 and choose the Number tab
in the left panel choose Date
in the right panel scroll select the format that looks like the style you want
click on OK
press Ctrl-1 and choose the Number tab
in the left panel choose Date
in the right panel scroll select the format that looks like the style you want
click on OK
A
ACarella
Hi Duke:
I did that and that format is not in the drop down. Any suggestions?
I did that and that format is not in the drop down. Any suggestions?
D
DazzaData
Hi,
use this custom format in format--> cells-->number, slect custom and then
type this in the box
dddd, dd mmm, yyyy
use this custom format in format--> cells-->number, slect custom and then
type this in the box
dddd, dd mmm, yyyy
D
Duke Carey
Then instead of Date choose Custom from the left panel, then in the Type box
enter
dddd, mmmm dd, yyyy
enter
dddd, mmmm dd, yyyy
A
ACarella
thank you.
DazzaData said:Hi,
use this custom format in format--> cells-->number, slect custom and then
type this in the box
dddd, dd mmm, yyyy
A
ACarella
thank you.
Duke Carey said:Then instead of Date choose Custom from the left panel, then in the Type box
enter
dddd, mmmm dd, yyyy