| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
| import excel 2007 in outlook 2007 | Excel Discussion (Misc queries) | |||
| How can you "save as" in excel 2007 (and word 2007)? | Excel Discussion (Misc queries) | |||
| Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
| Problems with my links to an excel 2007 file from a word 2007 file | Links and Linking in Excel | |||
Linear Mode
