formulas

  • Thread starter Thread starter tk williams
  • Start date Start date
T

tk williams

I have a workbook and the first sheet is for "data entry".
Sometimes when I enter the formula into the other sheets
to bring the info from one sheet to another it will only
show the formula and not the actual text, but other times
it will show the correct text. I have check the formating
and the formula and can't see anything wrong. I am using
Excel 97. HELP!!! THANKS...TKAY
 
TKAY

Hit CRTL + ~tilde) to toggle "View Formulas" on/off.

If "View formulas" is not toggled on........

Make sure the cells with Formulas are formatted to General and not Text.

Note: Re-formatting after the fact will not change what you see.

Do a Find and Replace if you have many.

replace what: =
replace with: =

Otherwise just select a cell and hit F2>ENTER

Gord Dibben Excel MVP XL2002
 
Gord...THANK YOU SO MUCH!!!! (:
I couln't get the view formulas to work or it did'nt look
like it was working..but I scooted over to some blank
cells and did a "Control X" then went back to my problem
cell and hit "Enter". Checked the formating to make sure
it was set to General and entered my formula and it
worked GREAT!!!!

THANK YOU, AGAIN!!!! TKAY
 
Back
Top