View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wendy Wendy is offline
external usenet poster
 
Posts: 3
Default Change number formating

Hi

I've been given an xml list which has a field with numbers in it. These
numbers should be currency, the number shown as 1000 should be £10.00. I
can't find the correct format to display it correctly. Can anyone help
please?

Thanks

Wendy