Quote Originally Posted by deadlyduck View Post
What determines the number of decimal places to use? Is there some cell that acts as a reference to know the appropriate number of decimal places for the selected currency?
No, there's no cell to act as a reference point. Basically I'm using this Journal and I'm aware of how many decimal place would a symbol have. So, was hoping that if I provide the 3 major currency symbols as sample data as they would have the similar decimal points. And if someone could help me code a solution I could expand the formula to include the other currencies.

For example:
1. EURUSD, GBPUSD, AUDUSD will have 5 decimal points i.e. #.#####
2. XAUUSD, XAUEUR, USOil, UKOil will have 2 decimal places i.e. #.## or ####.##
3. AUDJPY, EURJPY, GBPJPY, USDJPY will have 3 decimal place i.e. ##.### or ###.###

I do have a table in the MasterData worksheet. And I can add a column there to give reference to the number of decimal places for each symbol. But not sure how to go about it i.e. just plain number 2, 3, 5 or in formate such as #.##, #,###, #.#####