| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
When I enter 14 the cell shows 20
Ok, so I have been using Ecel for years, and although I do not often use a
lot of functions or formulas, I do know that when I enter a 5, I see a 5. So why when I enter 14 (in any cell) does it show up as 20? All other numbers seem to work just fine, but no matter which cell I enter 14, it changes to 20. This is a serious problem when trying to build spreadsheets and totaling numbers. Please help! -- What you do not protest, you promote. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter 14 the cell shows 20
One guess
Tools|Auto correct options type 14 in the replace box and if it comes up with 20 in the with box delete it Mike "Laura" wrote: Ok, so I have been using Ecel for years, and although I do not often use a lot of functions or formulas, I do know that when I enter a 5, I see a 5. So why when I enter 14 (in any cell) does it show up as 20? All other numbers seem to work just fine, but no matter which cell I enter 14, it changes to 20. This is a serious problem when trying to build spreadsheets and totaling numbers. Please help! -- What you do not protest, you promote. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter 14 the cell shows 20
Thank you Mike!
That did it! You Rock! Laura -- What you do not protest, you promote. "Mike H" wrote: One guess Tools|Auto correct options type 14 in the replace box and if it comes up with 20 in the with box delete it Mike "Laura" wrote: Ok, so I have been using Ecel for years, and although I do not often use a lot of functions or formulas, I do know that when I enter a 5, I see a 5. So why when I enter 14 (in any cell) does it show up as 20? All other numbers seem to work just fine, but no matter which cell I enter 14, it changes to 20. This is a serious problem when trying to build spreadsheets and totaling numbers. Please help! -- What you do not protest, you promote. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
When I enter 14 the cell shows 20
Now slap the person in the office who is laughing
"Laura" wrote: Thank you Mike! That did it! You Rock! Laura -- What you do not protest, you promote. "Mike H" wrote: One guess Tools|Auto correct options type 14 in the replace box and if it comes up with 20 in the with box delete it Mike "Laura" wrote: Ok, so I have been using Ecel for years, and although I do not often use a lot of functions or formulas, I do know that when I enter a 5, I see a 5. So why when I enter 14 (in any cell) does it show up as 20? All other numbers seem to work just fine, but no matter which cell I enter 14, it changes to 20. This is a serious problem when trying to build spreadsheets and totaling numbers. Please help! -- What you do not protest, you promote. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| cell shows 20. Formula shows 20. why not 540/27 | Excel Worksheet Functions | |||
| when I enter 5000 the spreadsheet shows 500. Why? | Excel Discussion (Misc queries) | |||
Hybrid Mode
