Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation vs formula
On one worksheet/tab the formula =len(a1) is being written in the cell- I
want it to calculate the length of cell a1. In another worksheet/tab (same file) the formula calculates correctly. Can you tell me why the formula is being written in the cell on one tab and/or how I can modify the options to calculate the formula vs writing it? Thanks Steve |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation vs formula
Steve
Sounds like the cell is pre-formatted as text so shows the formula rather than the result. Re-format to General then F2 and <Enter Gord Dibben MS Excel MVP On Tue, 5 Sep 2006 17:13:02 -0700, Steve Stad wrote: On one worksheet/tab the formula =len(a1) is being written in the cell- I want it to calculate the length of cell a1. In another worksheet/tab (same file) the formula calculates correctly. Can you tell me why the formula is being written in the cell on one tab and/or how I can modify the options to calculate the formula vs writing it? Thanks Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation vs formula
The cell was formatted to Text *before* the formula was entered.
You'll have to change the format to General or Number, and then re-enter the formula. Keyboard shortcut to do all this is: Select the cell, then, <Ctrl <Shift < ~ , Then <F2, Then <Enter -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Steve Stad" wrote in message ... On one worksheet/tab the formula =len(a1) is being written in the cell- I want it to calculate the length of cell a1. In another worksheet/tab (same file) the formula calculates correctly. Can you tell me why the formula is being written in the cell on one tab and/or how I can modify the options to calculate the formula vs writing it? Thanks Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Price function difference in Output formula vis a vis Manual Calculation | Excel Worksheet Functions | |||
Time Calculation Formula! | Excel Discussion (Misc queries) | |||
Initial Formula Calculation | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions |