| 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. |
| 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) | |||
Threaded Mode
