Concatenate a formatted number

[paulked]

Hi there.

I have a number in cell A1 ranging from 0 to 100,000,000 and have formatted the cell to give me a shortened version of this number (eg 1,234 displays 1.2k and 1,234,567 displays 1.2M).

However, when I try to concatenate this with text from other cells it gives me the full display of the number (eg "1,234,567 items selected" instead of "1.2M items selected").

Any ideas?

Thanks

[Bob Phillips]

Use

=B1&TEXT(A1,"[>=1000000]#,##0.0,,\M;[>=1000]#,##0.0,K;##0")

[paulked]

Many thanks, perfect