| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Numeric cell but shows as string?
I keep getting a #VALUE error when trying to divide two cells. They are
both numbers with decimals. In the error, I click to "show calculation steps" and see this: "850.00 "/29634 How can 850.00 be a string if the cell format type is numeric with two decimal places? How can I put the 850.00 as numeric and perform the calculation? Thanks, Brett |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining data (numeric format) in multiple cells into one cell (t | Excel Discussion (Misc queries) | |||
| resolving a numeric cell entry for its meaning | Excel Worksheet Functions | |||
| How to make a cell return the formatted value in a text string (i. | Excel Worksheet Functions | |||
| Cell formatting - "" shows as 1/0/1900 | Excel Discussion (Misc queries) | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Threaded Mode
