Thread: number format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
A A is offline
external usenet poster
 
Posts: 37
Default number format

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