really dumb cell() question

[ckennerdale]

sorry but this is a really silly question bt I cant find the answer

what I want to do is have a text contents frm one cell be the contents of another.

I assumed I would use cell()
e.g =CELL("contents",g6) - where g6 contains the text that I want in my new cell.

But the new cell only shows "=CELL("contents",g6)" as its value as opposed to the value of g6

thanks in advance

Caspar Kennerdale

 

[SkipVought]

Hi,

It would simply be
[tt]
=G6
[/tt]


Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[ckennerdale]

This doesnt to work

G6 has the value "March"

My new cell has the value "=G6" as opposed to "March which is what I want.

I there perhaps an options setting that is incorrect or a cell format. I have set the frmat to 'Text'

Caspar Kennerdale

 

[SkipVought]

Your cell containing =G6 is formatted TEXT and should be formatted General!

Format/Cell

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[KenWright]

Make that Format/Cell then F2 and enter as you need to effectively re-enter the formula

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------

 

[ckennerdale]

cheers

Caspar Kennerdale