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.

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]


wrote in message ups.com...
| 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.
|

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" wrote in message ...
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]


wrote in message ups.com...
| 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.
|

On Feb 10, 7:43 pm, "David McRitchie"
wrote:
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" wrote in ...
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]

wrote in oglegroups.com...
| 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 -

- Show quoted text -

Thanks david, it worked...