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 FormatNumberDate 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" 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 ... Dave If that format is not available in FormatNumberDate 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" 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 . |
All times are GMT +1. The time now is 11:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com