Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Can I copy the formatting of a cell in a IF Fucntion "VLOOKUP"? | Excel Worksheet Functions |