Formatting numbers within formulas

[JZB]

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

[mdmackillop]

Can you post a sample workbook?

[p45cal]

Have a look at the Text function, something like this perhaps?
=F27&TEXT(G27,"##.##")