Thread: [SOLVED] date option

Excel News group,

I would like to display "03/04/1997" instead of just the type listed
"03/04/97", I hope there is a option to do this.

I do have XP & excel 97

Thanks, Dave

Dave

If that format is not available in Format>Number>Date you can use Custom and
set for dd/mm/yyyy or mm/dd/yyyy.

Alternative.......go to Regional Options in Control Panel and change the
"short date" format to show the full year.


Gord Dibben Excel MVP

On Sat, 19 Mar 2005 18:24:02 GMT, "Dave" <dsutton@gate.net> wrote:

>Excel News group,
>
>I would like to display "03/04/1997" instead of just the type listed
>"03/04/97", I hope there is a option to do this.
>
>I do have XP & excel 97
>
>Thanks, Dave
>

Thanks, Dave

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:onso31l6f45l8uk2vvbf88efd7ea4me3nl@4ax.com...
> Dave
>
> If that format is not available in Format>Number>Date you can use Custom
> and
> set for dd/mm/yyyy or mm/dd/yyyy.
>
> Alternative.......go to Regional Options in Control Panel and change the
> "short date" format to show the full year.
>
>
> Gord Dibben Excel MVP
>
> On Sat, 19 Mar 2005 18:24:02 GMT, "Dave" <dsutton@gate.net> wrote:
>
>>Excel News group,
>>
>>I would like to display "03/04/1997" instead of just the type listed
>>"03/04/97", I hope there is a option to do this.
>>
>>I do have XP & excel 97
>>
>>Thanks, Dave
>>
>

Hie
Yes you can. On formart cells, number, go to custom and
change type: to be dd/mm/yyyy and you will smile at the
click of OK. respond please if it did not work but I'm
sure it will work.

>-----Original Message-----
>Excel News group,
>
>I would like to display "03/04/1997" instead of just the
type listed
>"03/04/97", I hope there is a option to do this.
>
>I do have XP & excel 97
>
>Thanks, Dave
>
>
>.
>