View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
C Tate[_2_] C Tate[_2_] is offline
external usenet poster
 
Posts: 7
Default Formatting currency query

At the moment my spreadsheet has figures in such as 303 and 528. These
numbers represent thousands. So 303 means £303,000 and 528 means £528,000.
How can I quickly change the basic figures to represent the currencies as
above? Thanks.