Excel - Showing Formula in Cells and not Results
Asked By CtDMone
10-Dec-08 01:16 PM
I have a text field, and programmed several formulas (left, mid, right) to
pull data from this text field. While in the formula editor, the formulas
worked correctly, however the sheet only displays the formula and not the
results. The sheet is not in "formula" mode (tools/options/view/formula box
is not checked), nor have I accidentally hit control ~.
--
-Al
Howard replied...
Is the cell that contains the formula formatted as text? If so, format it as
General and re-enter the formula.
AndreaJone replied...
You have probably got the cell formatted as text. To correct this:
Click on the cell containing the formula
Press CTRL+1 to bring up the Format Cells window
In the Number section set the format to General and click OK
Now press your F2 function key while in the same cell and press Enter, you
should now see the results.
Andrea Jones
www.stratatraining.co.uk
CtDMone replied...
It worked great. It seems odd, however, that I was using a text function and
the format of the cell being text was the problem. I would think that if it
was not text, I would get an error...Thanks for your help!
--
-Al
tab sheet be view with another at the same time? Excel Miscellaneous Discussions HiYes (1) Window (1) Goto (1) Hi Yes, you can; goto > Window> New Window> Window> Arrange and select your choice. HTH John hi yes. 03 - on the menu bar> window> new window then on the menu bar window> arrange. select view method. each window will display the selected tab. 07 = on the view tab> window group> new window then
Tom G Excel Worksheet Discussions Microsoft Excel (1) Panes (1) Excel (1) Horizontal.Adjust (1) Window.Window (1) Black87Bird (1) Window (1) No - Excel will allow you to freeze rows at the top and columns at the left - but that is it. Not without adding a window. Top window can contain static row(s) using Window> Freeze Panes. Bottom window can contain the row(s) to remain static at bottom. Gord Dibben MS Excel MVP Nor sure how to add a window, a advise? - - Regards Tom G Sorry, sat and though about opening another window for a
them Curious, Gamble Excel Miscellaneous Discussions Microsoft Excel (1) Excel (1) Worksheet (1) Workbook (1) Window.Window (1) Window (1) Checkbox (1) Go to Window, New Window. Then click again on Window, and click "Arrange". choose worksheet arrangement as desired. - - Best Regards, Luke M *Remember to click yes" if this post helped you!* Click on Window | New Window and you will have two windows open to the same sheet. You may need to
at the same time? Excel Miscellaneous Discussions Excel 2007 (1) Excel 2003 (1) Worksheet (1) Window (1) Window / New window as often as you need, then Window / Arrange . . ., to suit. - - David Biddulph In xl2003 menus: Window | New window Then Window | Arrange (tiled, horizontal or vertical) - - Dave Peterson ps. When you are done, you can select the window you want to close and hit ctrl-f4. - - Dave Peterson In Excel 2007, View, New