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? |
#2
|
|||
|
|||
try <edit<find replace "=" with "="
This works with some equations imported as text "Carrie" wrote: 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? |
#3
|
|||
|
|||
And while the cells are all still selected from the Edit & Replace,
If the returns of these cells appear left justified (meaning cells are Text formatted), You could perform a bulk transition to General format with: <Ctrl <Shift <~ -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "bj" wrote in message ... try <edit<find replace "=" with "=" This works with some equations imported as text "Carrie" wrote: 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? |
Reply |
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 |