If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Force calculation of all formulas in sheet
"soren" wrote in message
... Have a spreadsheet containing formulas produced via concatenate function thus they are text. When converting them to formulas they still behave as text. Using the built in calculation function doesn't work. Have to activate each cell press F2 and press enter. I figure ther must be a smarter way... cheers I've heard of people trying to make formulas by concatenating text before, but I've never understood why! Could you say why you have done this? I ask because my initial reaction to your comment that "there must be a smarter way" is not to build formulas like this in the first place. Maybe if you gave an example of what you are trying to achieve it would be possible to suggest an alternative approach. |
#2
|
|||
|
|||
Force calculation of all formulas in sheet
"soren" schreef in bericht ... Have a spreadsheet containing formulas produced via concatenate function thus they are text. When converting them to formulas they still behave as text. Using the built in calculation function doesn't work. Have to activate each cell press F2 and press enter. I figure ther must be a smarter way... cheers Sub fTwo() With ActiveSheet.UsedRange .Value = .Value End With End Sub |
#3
|
|||
|
|||
Force calculation of all formulas in sheet
"Paul" none schreef in bericht ... "soren" wrote in message ... Have a spreadsheet containing formulas produced via concatenate function thus they are text. When converting them to formulas they still behave as text. Using the built in calculation function doesn't work. Have to activate each cell press F2 and press enter. I figure ther must be a smarter way... cheers I've heard of people trying to make formulas by concatenating text before, but I've never understood why! Could you say why you have done this? I ask because my initial reaction to your comment that "there must be a smarter way" is not to build formulas like this in the first place. Maybe if you gave an example of what you are trying to achieve it would be possible to suggest an alternative approach. ctr-shift F9 (the same time) |
Thread Tools | |
Display Modes | |
|
|