Thread: When using ="cell" copy cell value and cell format
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default When using ="cell" copy cell value and cell format
Is this possible?

Unfortunately, no. A formula returns only the value.


--
Biff
Microsoft Excel MVP


"Jim" wrote in message
...
Hi

When using simple ="cell reference" (eg =c2) Excel should copy the cell
value AND the cell format.

Is this possible?

Thanks
--
Best Regards
Jim


Reply With QuoteReply With Quote