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.
Thanks for your help.
John.