PDA

View Full Version : Formatting numbers within formulas



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

mdmackillop
07-21-2009, 08:40 AM
Can you post a sample workbook?

p45cal
07-21-2009, 10:27 AM
Have a look at the Text function, something like this perhaps?
=F27&TEXT(G27,"##.##")