You can copy just the format by copying the source cell and then
doing Edit/Paste Special/Formats on the target.

If the source format might change and you want the target always
to reflect it, you can use the Camera Tool, aka Paste Picture Link
See http://j-walk.com/ss/excel/odd/odd04.htm for details.

hth
Andrew



On 24 Oct, 11:52, dim wrote:
Thanks Dave,
So how can I get the formatting to copy across aswell?



"Dave Peterson" wrote:
Formulas return values--not formats like this.

dim wrote:

Hi,
I'm using the old straightforward " = B5" to copy across text from B5 into
my new cell. No problems there, but I want whatever text formatting is in B5
to copy across aswell. Changing the format of my new cell is not an option
because it's locked for the user.
Any ideas?
Thanks....

--

Dave Peterson- Hide quoted text -

- Show quoted text -