functions not working
Thanks to both replies - I had formatted the cells as Text - realised 2
minutes after posting question. Once again, communities has come to the
rescue.
"Dave Peterson" wrote:
Format that offending cell as General (Format|Cells|Number tab)
and try reentering your formula.
Michael wrote:
When I enter a function, for example '=UPPER(A1)' where A1= john, the
following is displayed '=UPPER(A1)', not 'JOHN'. If I use the function wizard
the answer is displayed correctly as well
Other functions within the worksheet are working normally. For example ,
=DATEDIF(H17,I17,"y") returns a number not the function.
Any suggestions gratefully received.
--
Dave Peterson
|