convert text to number based on multiple headers

[excel01noob]

Hi

I have a dataset for which I need to first convert the data of several columns (from text to number) based on the column header

I don't want to define the column position as it varies from time to time, but the column header will always have the same header name.
In some occasions, some of the headers might not appear in the data set.

The header names most frequent are:

Quantity
Amount
Original currency Amount

These should be converted into numbers with 2 decimals

How do I get around this?

 

[excel01noob]

Hi Peter_SSs

Yes, just now, it worked marvelously, thank you very much!!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.