| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
functions not working
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
functions not working
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
functions not working
If you entered the formula correctly your probably in view formula mode.
try pressing cntrl + ` Mike "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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel FUNCTIONS stop working | Excel Worksheet Functions | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Changing the range of several averaging functions | Excel Discussion (Misc queries) | |||
| Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
| Application.Volatile not working as expected | Excel Discussion (Misc queries) | |||
Linear Mode
