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.
|