try
="Total shortfall is "&text(A5,"£.00")
I assume the £ is the appropriate format character. I am familarr with $ in
this situation.


"RajenRajput1" wrote:

Dear All,

I have a spreadsheet with a value of 123.889977 in cell A5

I have formatted it to currency and 0 decimal places so it looks like £124.

This figure is derived from a sum.

In cell C3 I have ="Total shortfall is "&A5
but it looks like this... Total shortfall is 123.889977

- How would I edit the formula to keep the formatting so that it reads
Total shortfall is £124 ?

Many thanks

Rajen