If A1 contains "November 2005" where the '2005' is BOLD and RED, how can I
put a formula in B5 something like "=A1" so that not only the value being
taken but also the BOLD and the RED format?
Thanks a Lot. SUNAN.

Hi sunan

Only possible with Event code (Change Event)
Do you want to use that ?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"sunan" wrote in message ...
If A1 contains "November 2005" where the '2005' is BOLD and RED, how can I
put a formula in B5 something like "=A1" so that not only the value being
taken but also the BOLD and the RED format?
Thanks a Lot. SUNAN.

Further to Ron, in Excel only text constants can have mixed formatting.
Never numbers and never formulas, even when they return text.

--
Jim
"sunan" wrote in message
...
If A1 contains "November 2005" where the '2005' is BOLD and RED, how can
I
put a formula in B5 something like "=A1" so that not only the value being
taken but also the BOLD and the RED format?
Thanks a Lot. SUNAN.