Cell linking displayed in text

I am trying to have a cell in a diffrent work sheet display information from another sheet.

I entered ='Weapons Table'!A48 and it is displaying in text not what is actually in that cell.
on the cell above it I have entered ='Weapons Table'!A47 and it displays fine.

I've tried typing = then just clicking the cell, and it is still just displaying it as text. I've spent 3 days on this sheet and have only 1 error, that is driving me crazy.

I'm on excel 2007 and have exhausted all my collegues who have any excel expertise. please help.

What does this mean:

it is still just displaying it as text

you see the formula and not the result, or a number displayed as text?

what is in the original cell?
what exactly is displaying in the cell referencing it?
have you checked the cell's format and set it to the one you want?

Maybe post a workbook, so we can have a look at the actual data?

Try to do an edit|replace of = with =

See my last reply...

And replace = with = and click Replace All.

You can also select each column independently, starting from row 9 down.. and then go to Data|Text to columns and simply click Finish... repeat for each column from row 9 down...

In the Home Tab, go the Find/Replace icon (binoculars) and choose Replace.

Enter = sign in both fields.

Click Replace All.

Originally Posted by beefree

Nevermind I get the text to column. Thanks for the help. now, do you know any good plumbers in Sounthern Oklahoma?

I live in Canada... so no, sorry.. good luck with that.