Thread: How do I use a relative cell reference that will copy the format?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JBeaucaire[_85_] JBeaucaire[_85_] is offline
external usenet poster
  
Location: Bakersfield, CA
Posts: 45
Send a message via Skype™ to JBeaucaire[_85_]
Default How do I use a relative cell reference that will copy the format?
Give this a try:

Edit PasteSpecial Values and number formats
--
"Actually, I AM a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Brian" wrote:

What I'm trying to do is copy over the formatting that I've done to a cell
when I'm trying to use a relative reference to that cell. Aside from pasting
the format, is there some other way to copy the formatting as well as the
values within the cell?
Reply With QuoteReply With Quote