Hi all,
I've put together a matrix for currency rates and naturally I want column width to be standard across the range. By extension then, I need to retain a standard character length for FEX rates i.e. only show the first six numerical digits, regardless of decimal places.
At present, I've formatted cells as below:
_(* #,##0.00000_);[Red]_(* (#,##0.00000);_(* "-"_);_(@_)
By way of example, the above formatting generates the below results for the two different currency pairs (one strong pair e.g. GBP:USD and one weak e.g. USD : IRR):
GBP : USD - 1.15818
USD : IRR - 42,350.91551
Because of the formatting instruction, there are five numerical digits after the decimal point, whereas I want to limit the entire FEX rate to six digits, regardless of decimal point position i.e.
GBP : USD 1.15818
USD : IRR 42,350.9
Can anyone advise on how to do this? My feeling is that I'm overlooking something very simple, but I haven't found the answer yet...
I've put together a matrix for currency rates and naturally I want column width to be standard across the range. By extension then, I need to retain a standard character length for FEX rates i.e. only show the first six numerical digits, regardless of decimal places.
At present, I've formatted cells as below:
_(* #,##0.00000_);[Red]_(* (#,##0.00000);_(* "-"_);_(@_)
By way of example, the above formatting generates the below results for the two different currency pairs (one strong pair e.g. GBP:USD and one weak e.g. USD : IRR):
GBP : USD - 1.15818
USD : IRR - 42,350.91551
Because of the formatting instruction, there are five numerical digits after the decimal point, whereas I want to limit the entire FEX rate to six digits, regardless of decimal point position i.e.
GBP : USD 1.15818
USD : IRR 42,350.9
Can anyone advise on how to do this? My feeling is that I'm overlooking something very simple, but I haven't found the answer yet...