| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to change a visible formula into a value? (Quickbooks download
I have downloaded a Quickbooks file, which has changed everything into text.
The formula only displays the formula and doesn't calculate the values. I have tried formatting the cells (used in the formula, as well as the formula itself), and they show $0 if I format to a numerical value. I have tried to copy the column into a different workbook and paste as values only, but still nothing. Does anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Cannot change a formula | Excel Discussion (Misc queries) | |||
| Can I use TODAY Function in a formula that will not change it the. | Excel Discussion (Misc queries) | |||
| How to use formula auditing to change upper case to Title Case. | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
Threaded Mode
