Hello,

I have an Input spreadsheet, where the user can enter data in various formats ($, % etc). There is another sheet that does the calculations automatically based on the data entered by the user. However the calculations are not picking up the format that the user has chosen. Is there any workaround I can use that the formula will detect the format from the input cell and then apply it to the calculated fields without using a Macro.

Regards,
Kalyan Verma