Change a number into text with the use of currency number format

[sunboy]

Hi

I am asking for a formula to change a number into text with the use of currency number format.

Thank you.

Regards,

Sunboy

[AliGW]

Where? There are NO annotations in the workbook explaining what you want and where.

You cannot change a number into text with a currency format - it's a contradiction in terms.

[sunboy]

Hi

I want to change the amounts in row 11, Cell N11 and place it to cell F17 but in a text form, and Cell F11 to Cell F18, and Cell V11 to Cell F19, as shown in the desired solution. You can use any other formula if the currency format is not applicable.

Thank you

[AliGW]

Is this what you mean? Or do you want something more complex/automated? if so, you need to explain in more detail and stop leaving us to guess.

I simply put a formula to get the amount and formatted each cell with a different currency.

[sunboy]

Hi

Thank you for the formula, however I wanted a formula which can automatically produce the results. The solution with formatting cells is best but I have little knowledge about formatting, and I'm yet to learn it.

Regards,

Sunboy

[AliGW]

OK - if this is just for visuals, it's easy, but if you will want to further use the results in formulae, then turning them into text is not a good idea.

For instance, you can do this:

="ZWL "&N11

[josephteh]

Cell F17 =N5&TEXT(N11,"#,##0.00")

[Bo_Ry]

Please try at
A17
="Cash held in "&CHOOSE(ROWS(A$17:A17),$N$5,$F$5,$V$5)&TEXT(MAX(CHOOSE(ROWS(A$17:A17),$I$7:$I$14,$A$7:$A$14,$Q$7:$Q$15)),""" Account (as at""dd/mm/yy")

F17
=CHOOSE(ROWS(F$17:F17),$N$5,$F$5,$V$5)&FIXED(LOOKUP(9^9,CHOOSE(ROWS(F$17:F17),$N$7:$N$14,$F$7:$F$14,$V$7:$V$15)))

[sunboy]

Hi Bo_Ry

Thank you for the wonderful formulas.

Regards,

Sunboy