Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell format
How do i make a cell take on the format of another cell's format..
for example if cell A1 has the formula =C5. let say C5 is formated in percentage and i need A1 to be percentage.. if i change C5 to currency how do i make cell A1 automatically take up the cell's format (C5)? -- help a friend help you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell format
You would need code to do that, no formatting or formulas will do that
-- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "ernie" wrote in message ... How do i make a cell take on the format of another cell's format.. for example if cell A1 has the formula =C5. let say C5 is formated in percentage and i need A1 to be percentage.. if i change C5 to currency how do i make cell A1 automatically take up the cell's format (C5)? -- help a friend help you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell data format | Excel Discussion (Misc queries) | |||
Bring the cell format along with the cell value from a reference c | Excel Worksheet Functions | |||
Reference Cell in custom format???? | Excel Discussion (Misc queries) | |||
Why does my format keep changing in the cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions |