Copy Across Formatting aswell using "=[Cell Ref]" ?
 

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....

Copy Across Formatting aswell using "=[Cell Ref]" ?
 

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

Copy Across Formatting aswell using "=[Cell Ref]" ?
 

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

Copy Across Formatting aswell using "=[Cell Ref]" ?
 

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 -

Copy Across Formatting aswell using "=[Cell Ref]" ?
 

Thanks Andrew,
That looks like it will work a treat. I guess I just learned another new
thing about MS Excel. :D Bye for now.

"Andrew Taylor" wrote:

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 -