Hi,

I am currently working on a spreadsheet and I need to keep the formatting of another cell.

=CONCATENATE("Sheet to ",B8," ","£",TEXT(B10,"######.##"))
is what I am currently using, but instead of putting in £1.00 it put in £100.

Could anyone help me to get this right?

Thanks