Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function returns itself vice results
I typed in function =LEN(H2) and when I hit return, the function appears in
the cell but the result does not appear. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function returns itself vice results
the cell is apparently formatted as text. Change it to General and then
press F2 followed by enter "BethD" wrote: I typed in function =LEN(H2) and when I hit return, the function appears in the cell but the result does not appear. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function returns itself vice results
Try this:
Select the cell in question Goto the menu FormatCellsNumber tabGeneralOK Hit funtion key F2 Hit ENTER -- Biff Microsoft Excel MVP "BethD" wrote in message ... I typed in function =LEN(H2) and when I hit return, the function appears in the cell but the result does not appear. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function returns itself vice results
I tried this and it did not work. I am stymied. It is formatted as General.
I took off any bold, centering, turned it vanilla as I could. The F2 and enter still leaves me with =LEN(H2) "T. Valko" wrote: Try this: Select the cell in question Goto the menu FormatCellsNumber tabGeneralOK Hit funtion key F2 Hit ENTER -- Biff Microsoft Excel MVP "BethD" wrote in message ... I typed in function =LEN(H2) and when I hit return, the function appears in the cell but the result does not appear. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function returns itself vice results
Check this setting....
ToolsOptionsView tabin Window options uncheck FormulasOK -- Biff Microsoft Excel MVP "BethD" wrote in message ... I tried this and it did not work. I am stymied. It is formatted as General. I took off any bold, centering, turned it vanilla as I could. The F2 and enter still leaves me with =LEN(H2) "T. Valko" wrote: Try this: Select the cell in question Goto the menu FormatCellsNumber tabGeneralOK Hit funtion key F2 Hit ENTER -- Biff Microsoft Excel MVP "BethD" wrote in message ... I typed in function =LEN(H2) and when I hit return, the function appears in the cell but the result does not appear. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Formula Returns the Wrong Results. | Excel Worksheet Functions | |||
SUM formula results returns 0 value | Excel Worksheet Functions | |||
Excel "mode" function returns different results based on sort orde | Excel Worksheet Functions | |||
Function To Convert Liters To Imperial Gallons & Vice Versa | Excel Worksheet Functions |