Concatenate formula not taking decimal places/currency sign

Hi all, in brief, i have lets say a table with rows that contain the following data.

SKU - PRICE - SALEPRICE - DESCRIPTION - SALEDESCRIPTION

What I am trying to do, is to make a concat formula that says:

SALEDESCRIPTION = DESCRIPTION+price was+PRICE+now+SALEPRICE

In essence so that i can simply pull down the formula, and all our product descriptions have 'special offer, was xx (price) is now xx (sale price).

This works fine, except that in the SALEDESCRIPTION, the amounts from the price and saleprice fields are being brought over without decimal places and without currency symbol.

I have tried formatting those two columns as currency or accounting but neither works.

Thanks in advance,

Steve Quinn
E-Commerce Team
Woods of Morecambe Limited
www.woods-online.co.uk

Try using the TEXT() function

e.g.

=DESCRIPTION+TEXT(price was,"$0.00")+TEXT(PRICE+now,"$0.00")+SALEPRICE

You can play a bit with the format to get desired look.

Hi there, many thanks for replying. I couldnt get it to work, so for the sake of this excercise, i have uploaded my spreadsheet with just the first row in it.

Thanks again in advance....

Steve

Try:

=CONCATENATE(E2,G2,TEXT(C2,"£0.00"),H2,TEXT(D2,"£0.00"),I2)