Force calculation of all formulas in sheet

[soren]

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

 

[Paul]

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.

 

[Gerrit]

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

 

[Gerrit]

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)