JZB
07-21-2009, 07:57 AM
Hi Guys
I have a set of numbers which i want to incorporate into an & formula.
However i want the numbers to be 2 decimal places within the formulae
1.64ASHAW_GBP/USD_1.642309
1.64ASHAW_GBP/USD_1.642309
Tha above is an example.
I have formatted the first column to decimal places: 1.64. But the string formula is pulling back the original number of 1.642309. how can i incorporate the cells format into the formulae?:help
Sorry guys stuck on this one
Thanks
Jon
I have a set of numbers which i want to incorporate into an & formula.
However i want the numbers to be 2 decimal places within the formulae
1.64ASHAW_GBP/USD_1.642309
1.64ASHAW_GBP/USD_1.642309
Tha above is an example.
I have formatted the first column to decimal places: 1.64. But the string formula is pulling back the original number of 1.642309. how can i incorporate the cells format into the formulae?:help
Sorry guys stuck on this one
Thanks
Jon