You could use the Custom Format:

$#,##0.0"m"

HTH
Elkar



"A" wrote:

Hi
Is there any way to format a number to 1 decimal place which includes the
currency symbol at the start and text at the end eg m (for millions).

eg £24.5m

I want to change the format so that I can still add a list of numbers

Regards
Adrian