changing cell formats based on other cell content

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
Is there a means to change the unit formatting of a cell based on a selection elswhere in the workbook? I would like to be able to change between "ft" and "m" in all cells containing length values based on a single dropdown selection.

Thanks for your help.

John.
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
amplifying info

I do not need to convert the information as the person entering the data will enter it in either metric or standard units as required by the end customer.

Thanks again.
 

vmottert

Board Regular
Joined
Aug 30, 2003
Messages
215
You can use a conditional formula...

=if(C5=1,formula&"ft",formula&"meters")

where C5 is an user entered value. Hope this helps.

Regards,

Vernon
 

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
Maybe I don't understand what you sent me

Thanks for your input Vernon. I am not certain what you are telling me to do. Are you implying I will need to go to each cell and edit the entires for the calcs? If so that can be done. However, what I am trying to accompish is to have a single entry in the workbook which defines whether or not I am using metric values. If I am measuring length in "meters" then I want all the cells to indicate "m" after the length values I enter and the results of all calculations that give length results. If I am using "feet" then I want to indicate "ft" after all my length values.

Thanks again
John
 

vmottert

Board Regular
Joined
Aug 30, 2003
Messages
215
John,

In my example, if the user entered "1" in cell C5, the conditional formula would use the "True", or first formula. If there was anything other than a "1" in C5, the second formula would be used. Replace "formula" with your formula. The &"ft" or &"m" would append the reuult with the measurement label.

Vernon
 

jslomax

New Member
Joined
Nov 20, 2005
Messages
15
Thanks for your help.

this will work for the cells I have calculations in. Is there a way to alter the formats of cells that I enter data into? Some values I enter are just measurements and the cells don't have a formula attached to them.

Thanks again

John.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,989
Members
412,633
Latest member
simon_elvin
Top