Excel 2002 show data not formula ASAP Please

[DougP]

I have this in my cell to make a barcode

="*" & Data!A2 & "*"

which is what it shows
I need it to show
*389829* which is what is in cell A2 on the Data TAB

I have had this working before

Help !!!


DougP, MCP, A+

 

[carrr]

Try ="*" & "Data!A2" & "*"

Tired of waiting for an answer? Try asking better questions. See: faq222-2244

 

[DougP]

That can't work then it forces the Data!A2 in a string which is not what I want!

DougP, MCP, A+

 

[GoDawgs]

Your cell is formatted as text...add an apostrophe in front of the equals sign, hit enter, then go back in and delete the apostrophe out and hit enter again.

Hope that helps.

Kevin

 

[AnotherHiggins]

Go to Tools > Options

On the View tab, make sure that the box beside Formulas is not checked.

[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886

 

[CEN7272]

I know this is going to sound silly but something similar just happened to a co-worker. He hit the 'equals' button on the formula bar and that help window dropped down, he hit OK and for some reason it worked, it must have been some kind of glitch. Its worth a try.

If all your formulas are showing try hitting 'Ctrl' + '~' and that should toggle between showing the functions and the solutions



-Clay
claysdays.blogspot.com

 

[DougP]

It is not
It works sometimes but not others
If I pick a new cell below and key it in, it works
If I copy it or edit it, then it changes to the text.
Is there a way to force it back to show data

DougP, MCP, A+

 

[DougP]

CEN7272 I tried that It show all formulas then onlt puts back the ones it wants and the others are still messed up.
its actually
ctr+` which is the Accent Grave but its the smae key right so anyway

DougP, MCP, A+

 

[DougP]

So here is my Fix I had to delete the cells and then it asked Shift cells UP
I then wrote this macro

Public Sub MakeFormulas()
    [h6] = "=Data!B2"
    [h7] = "=Data!C2"
    [h8] = "=Data!E2"
    [h9] = "=Data!F2"
    [h10] = "=Data!G2"
    [h11] = "=Data!H2"
End Sub

So now it works


DougP, MCP, A+