| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't calculate values of fields with a $.
I need to paste a column of home sales prices, and a column of home square
footages, and calculate based on those two values. (sales price/square footage) BUT...the pasted list is in this format: "$250,000." Whenever I make the calculations, I get a "VALUE!" error. This is because it doesn't understand "$250,000" has a value. How can I get it to understand that "$250,000" has a value of 250,000? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate averages not including zero values | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
| How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
| Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Threaded Mode
