![]() |
Cell Formating
Update to previous!!!! It is the date I am having trouble with? the
previous formatting offered the diplay option of Tuesday March 9, 2010 and would display upon entering 3/9. The Vista version does not offer that option and displays Mar. 9 10 and only if you enter 9/3. Entering 3/9 gives me March 1 2009? |
Cell Formating
Check your early post.
Walter wrote: Update to previous!!!! It is the date I am having trouble with? the previous formatting offered the diplay option of Tuesday March 9, 2010 and would display upon entering 3/9. The Vista version does not offer that option and displays Mar. 9 10 and only if you enter 9/3. Entering 3/9 gives me March 1 2009? -- Dave Peterson |
Cell Formating
So how do you want the date to appear?
If it's Tuesday Mar,09,2010 then custom format to dddd mmm,dd,yyyy If it's 3/9 make it m/d Rather than a new posting, if you have an update again before a response please update by reply to your own posting so it's all together. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Walter" wrote: Update to previous!!!! It is the date I am having trouble with? the previous formatting offered the diplay option of Tuesday March 9, 2010 and would display upon entering 3/9. The Vista version does not offer that option and displays Mar. 9 10 and only if you enter 9/3. Entering 3/9 gives me March 1 2009? |
Cell Formating
Hi Walter
Right click your start buttonControl PanelRegional settings It sounds as though they are different on your laptop. -- Regards Roger Govier Walter wrote: Update to previous!!!! It is the date I am having trouble with? the previous formatting offered the diplay option of Tuesday March 9, 2010 and would display upon entering 3/9. The Vista version does not offer that option and displays Mar. 9 10 and only if you enter 9/3. Entering 3/9 gives me March 1 2009? |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com