add text before formula returning currency format

Topic

New Reply

Formula is =Max(J:J) and it returns a currency format ” $2,000″ [without the quotes]
I want to add text [GGH] before the return and keep the currency format and see this in the cell – “GGH $2,000” [without the quotes]
But I want Excel to see the numerical value of $2,000 for that cell so it can be used in other formulas.

I also need to do the same with this formula, =(LOOKUP(9E+307,B:B))-MAX(B:B), and others.
Would I have to alter the method?

Thanks.

Reply | Quote

Replies

SkiPro,

What you need is a Custom Format and then just apply that to any cell you wish to have the prefix.
38566-SkiproCustomFMt
HTH :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

FWIW, you can also use the TEXT function:
=”GGH “&TEXT(Max(J:J),”$ #,##0”)
for instance. RG’s has the benefit of leaving the result as a number if you need it for other calculations, whereas this allows you to use another cell or formula for the text to concatenate (and the format if you wish).

Reply | Quote

RG & Rory,
Thanks.

Reply | Quote