| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula shows as text
I have a spreadsheet that I inserted a formula =Trim(A2), after I typed this
and hit the enter key no formula appeard only the text. I had selected all cells and formatted as text prior to using the formula. Do I have some hidden characters or something that causes my formula from not showing? -- Thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula shows as text
If you format a cell as text and then enter a formula in the cell, your
formula is a text string, not a formula. Format as general. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "hilltop55" wrote: I have a spreadsheet that I inserted a formula =Trim(A2), after I typed this and hit the enter key no formula appeard only the text. I had selected all cells and formatted as text prior to using the formula. Do I have some hidden characters or something that causes my formula from not showing? -- Thanks for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula shows as text
Re-format to General then re-enter the formula.
By formatting to text your formula remains as text. Gord Dibben MS Excel MVP On Fri, 2 Feb 2007 11:51:01 -0800, hilltop55 wrote: I have a spreadsheet that I inserted a formula =Trim(A2), after I typed this and hit the enter key no formula appeard only the text. I had selected all cells and formatted as text prior to using the formula. Do I have some hidden characters or something that causes my formula from not showing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Some text shows in the formula bar but not in the cell. | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
Linear Mode
