Formatting lost when copied by formula!

  • Thread starter Thread starter ppsza
  • Start date Start date
P

ppsza

Hi,

I'm having a problem retaining format in a target cell where a formul
"copies" the contents from another cell. Here's an example tha
describes the problem in detail:

Say I have the following text in cell A1: "Some text." Say, also, tha
the word "text" is bolded. In cell B2 I have a formula, =A1, tha
"copies" the content of cell A1. I can see the content of cell A1 i
B2, but without the bold (or any other formatting, including backgroun
color, etc.).

My question, of course, is how do I retain the original formatting?

Thank you
 
what other post? there's only one post from this guy that I can see.

Hi
see your other post
 
Hi
should have been more precise: The OP posted this question
also in Excel.misc
 
Back
Top