Keep Original Number format when mixing Text with Link to cell

[James8761]

I am trying to type words in to a cell and also add a number by way of linking to a cell reference and then add more text after.

e.g. I want the outcome to be Your balance at 31 May was 200,000. Please check if you have a difference.

I start off with "Your balance at 31 May was "&C3&" Please check if you have a difference"

I almost get what I want as the formula returns................ Your balance at 31 May was 200000 Please check if you have a difference

However I would like to keep the number formatting the same as it is in it's own cell. i.e. I would like my answer to be Your balance at 31 May was 200,000 Please check if you have a difference.

Does anyone know how I can tweak this formula slightly please?

James

 

[RoryA]

You can use TEXT but you have to specify the format - you can't automatically pick up whatever format is in that cell:

="Your balance at 31 May was "&TEXT(C3,"#,##0")&" Please check if you have a difference"

 

[James8761]

You can use TEXT but you have to specify the format - you can't automatically pick up whatever format is in that cell:

="Your balance at 31 May was "&TEXT(C3,"#,##0")&" Please check if you have a difference"

Excellent. Works right away. Thank you very much.