Create a new number format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C J - 05 Mar 2008 03:30 GMT

Can anyone tell me how to create a new number format so that the selected
dates (Dec 07) will appear only as the full names of the days of the week
(Sunday, Monday etc.)?
Thanks,
C J

Reply to this Message

Tyro - 05 Mar 2008 03:43 GMT

It's called custom formatting. Excel help has several examples. Select the
cells with the dates and apply the custom format dddd

Tyro

> Can anyone tell me how to create a new number format so that the selected
> dates (Dec 07) will appear only as the full names of the days of the week
> (Sunday, Monday etc.)?
> Thanks,
> C J

Reply to this Message

OssieMac - 05 Mar 2008 05:09 GMT

"dddd"

Three d's give you abbreviated day of week. 4 gives full spelling.

same with mmm and mmmm

Signature

Regards,

OssieMac

> Can anyone tell me how to create a new number format so that the selected
> dates (Dec 07) will appear only as the full names of the days of the week
> (Sunday, Monday etc.)?
> Thanks,
> C J

Reply to this Message

C J - 07 Mar 2008 22:53 GMT

Thanks to both of you.
C J

> "dddd"
>
[quoted text clipped - 7 lines]
>> Thanks,
>> C J

Reply to this Message

Rate this thread: