Quick Excel Question

[razor007]

Does any Excel guru out there know how you can test the contents of a cell to see if it's contents are a formula rather than a value - here's the kicker - not using vba?

Thanks.

[Ganon11]

What would you be using to test this?

[MMcCarthy]

Does any Excel guru out there know how you can test the contents of a cell to see if it's contents are a formula rather than a value - here's the kicker - not using vba?

Thanks.

It very much depends on what you're doing but if you copy the cells and use the paste special and choose formulas then all the cells with fomulas will show the formula rather than the data.

Mary

[link]

hi there,

try control + left single quote...it will shows you the content of every single cell inlcuding the formula...

hope this works.

L][nk