formulas not being recognised

V

vinisunodh

Hv entered all the correct formulas but they give the desired values
only after specifically recognising the cells, i.e have to do an "F2"
to realise the formulas.
 
M

macropod

Hi,

At a guess, Id' say you input the formulae into cells formatted as text, which causes then to display the formulae instead of the
results. If you then change the formatting to something else (eg general), you'll still need to select them (eg F2) and press
<Enter> to get them to display the calculated results.

Cheers

--
macropod
[MVP - Microsoft Word]


| Hv entered all the correct formulas but they give the desired values
| only after specifically recognising the cells, i.e have to do an "F2"
| to realise the formulas.
|
 
D

David McRitchie

Hitting F2 then Enter, is the same as an original
entry. You have calculation turned off. to turn back on.
Tools, Options, Calculation (tab),
Calculation: [x] Automatic

If you have a persistent problem of a macro turning
calculation off, but forgetting to turn it back on afterwards
you may have to put some extra code when starting up.

'---- do not include following code in your personal.xls Auto_Open
'-- Run-time error '1004'.
'-- Method 'Calculation' of object '_Application' failed
If Application.Calculation <> -4105 Then
'-4105 automatic, -4135 manual, 2 semi-automatic
MsgBox Application.Calculation & " <calculation in> " & _
ActiveWorkbook.FullName
Application.Calculation = xlAutomatic
MsgBox Application.Calculation
End If
 
V

vinisunodh

Hitting F2 then Enter, is the same as an original
entry. You have calculation turned off. to turn back on.
Tools, Options, Calculation (tab),
Calculation: [x] Automatic

If you have a persistent problem of a macro turning
calculation off, but forgetting to turn it back on afterwards
you may have to put some extra code when starting up.

'---- do not include following code in your personal.xls Auto_Open
'-- Run-time error '1004'.
'-- Method 'Calculation' of object '_Application' failed
If Application.Calculation <> -4105 Then
'-4105 automatic, -4135 manual, 2 semi-automatic
MsgBox Application.Calculation & " <calculation in> " & _
ActiveWorkbook.FullName
Application.Calculation = xlAutomatic
MsgBox Application.Calculation
End If

--

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm



macropod said:
Hi,
Click to expand...
At a guess, Id' say you input the formulae into cells formatted as text, which causes then to display the formulae instead of the
results. If you then change the formatting to something else (eg general), you'll still need to select them (eg F2) and press
<Enter> to get them to display the calculated results.
Click to expand...
| Hv entered all the correct formulas but they give the desired values
| only after specifically recognising the cells, i.e have to do an "F2"
| to realise the formulas.
|- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks david, it worked...
 
Top