copy formula style

[marco g 3284]

i'm trying to copy a cell (both text and format) from one tab to another tab
within the same document but keep getting just the text. is there a formula
aside from '=Sheet1!' that will work for it?

 

[Jay Freedman]

i'm trying to copy a cell (both text and format) from one tab to
another tab within the same document but keep getting just the text.
is there a formula aside from '=Sheet1!' that will work for it?

Better to ask in an Excel newsgroup.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.