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 |
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 |
All times are GMT +1. The time now is 04:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com