Excel 2007
When I type the number 3 in a cell it automatically converts it to "three".
Any other number I type displays as a number. I tried changing the format to number, accounting, etc. but no change. Any ideas how to fix this? |
Excel 2007
Hi,
Looks like an "auto correct" problem, I only have Excel 2000 so can't tell you where to look in 2007 but try finding the "auto correct" feature and see if the number 3 is in the list! Regards! Jean-Guy "Snurmi37" wrote: When I type the number 3 in a cell it automatically converts it to "three". Any other number I type displays as a number. I tried changing the format to number, accounting, etc. but no change. Any ideas how to fix this? |
Excel 2007
Thank you!!! Your solution worked.
"Jean-Guy" wrote: Hi, Looks like an "auto correct" problem, I only have Excel 2000 so can't tell you where to look in 2007 but try finding the "auto correct" feature and see if the number 3 is in the list! Regards! Jean-Guy "Snurmi37" wrote: When I type the number 3 in a cell it automatically converts it to "three". Any other number I type displays as a number. I tried changing the format to number, accounting, etc. but no change. Any ideas how to fix this? |
Excel 2007
You're welcome...glad I could help!
Regards! Jean-Guy "Snurmi37" wrote: Thank you!!! Your solution worked. "Jean-Guy" wrote: Hi, Looks like an "auto correct" problem, I only have Excel 2000 so can't tell you where to look in 2007 but try finding the "auto correct" feature and see if the number 3 is in the list! Regards! Jean-Guy "Snurmi37" wrote: When I type the number 3 in a cell it automatically converts it to "three". Any other number I type displays as a number. I tried changing the format to number, accounting, etc. but no change. Any ideas how to fix this? |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com