Excel Problem
When I type 3/3 in excel (English Version), it come out 3月3日! May I know the
solution ? Thanks & Regards |
Excel Problem
What if you type just the / (select the formula bar and type it), if it
gets replace then most likely you can find it under autocorrect -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Irene" wrote in message ... When I type 3/3 in excel (English Version), it come out 3?3?! May I know the solution ? Thanks & Regards |
Excel Problem
Check the font you are using.
Check the cell number format. Check Auto Correct Options -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Irene" wrote in message When I type 3/3 in excel (English Version), it come out 3月3日! May I know the solution ? Thanks & Regards |
Excel Problem
Hi Irene,
That's a Chinese date, but you mentioned your Excel is the English version. You may want to check Regional and Language Options under Windows Control Panel. Most likely it's set to some kind of Chinese. -Simon "Irene" wrote: When I type 3/3 in excel (English Version), it come out 3月3日! May I know the solution ? Thanks & Regards |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com