Hi Excel Lovers lol,
I would like to format a date input so that the result would be full day and another to be the following date.
Example
1) Sunday
2) 28 August 2005
Regards
Hi Excel Lovers lol,
I would like to format a date input so that the result would be full day and another to be the following date.
Example
1) Sunday
2) 28 August 2005
Regards
Format>Cells>Number tab>catagory date>type>
hth
"bach" wrote:
>
> Hi Excel Lovers lol,
>
> I would like to format a date input so that the result would be full
> day and another to be the following date.
>
> Example
>
> 1) Sunday
> 2) 28 August 2005
>
> Regards
>
>
> --
> bach
> ------------------------------------------------------------------------
> bach's Profile: http://www.excelforum.com/member.php...o&userid=26134
> View this thread: http://www.excelforum.com/showthread...hreadid=399831
>
>
Get a strange string
16t16
bach,
1) Custom format as "dddd" (without the quotes)
2) Custom format as "dd mmmm yyyy" again without the quotes.
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
"bach" <[email protected]> wrote in message
news:[email protected]...
>
> Hi Excel Lovers lol,
>
> I would like to format a date input so that the result would be full
> day and another to be the following date.
>
> Example
>
> 1) Sunday
> 2) 28 August 2005
>
> Regards
>
>
> --
> bach
> ------------------------------------------------------------------------
> bach's Profile:
> http://www.excelforum.com/member.php...o&userid=26134
> View this thread: http://www.excelforum.com/showthread...hreadid=399831
>
bach,
You don't say who it is you a replying to. If it is Ray then I think the *
hth * was meant to be * hope this helps *
If it was a reply to me then please post back.
--
Regards
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
"bach" <[email protected]> wrote in message
news:[email protected]...
>
> Get a strange string
>
> 16t16
>
>
> --
> bach
> ------------------------------------------------------------------------
> bach's Profile:
> http://www.excelforum.com/member.php...o&userid=26134
> View this thread: http://www.excelforum.com/showthread...hreadid=399831
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks