Formula showing insteaad of result

[madforgolf]

Hi ,

Im using vlookup from a range in another workbook and it only shows the formula not the result. Now the thing is the cell below is the same and it work!!! I have tried and checked formats in both books and they are idenitical but having no joy. Even if i open the 2 files and only use the vloopup that way it still shows the formula in some cells.Baffled.

Cant attach as work pc.

Any help would be pleased.
excel 2010

cheers
Marty

 

[mmmarks]

try dis,

just hit ctrl+`

 

[Michael M]

Also, check to make sure the cell in question isn't formatted as text !!

 

[madforgolf]

Thanks for the replies,
mmmmarks
cTRL+' only chages cell value to a copy of a cell above that works,
Micheal M
Both book are cells set to General (except where a date is required)

dont see whats up.

 

[Michael M]

ADVERTISEMENT

A little trick to try....provided by MVP PaddyD

1) Go to - Edit | Go to | Special | Formulas. Press OK
2)Go to - Edit - Replace...
3) Find: =
4) Replace with : =
5) Click Replace all

 

[madforgolf]

Michael M
Is that replace with = or : =
I will try this shortly.

Sorry the version of excel is 2007 my mistake.

Marty

 

[Michael M]

ADVERTISEMENT

No, just =

 

[c_m_s_jr]

A little trick to try....provided by MVP PaddyD

1) Go to - Edit | Go to | Special | Formulas. Press OK
2)Go to - Edit - Replace...
3) Find: =
4) Replace with : =
5) Click Replace all

SWEET!...That is a great trick to force formulas that have text format

 

[Michael M]

Yeah, wish I could be smart enough to take the credit.....