Thread: Change number formating
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
  
Posts: 1,047
Default Change number formating
thanks for the feedback

regards

"Wendy" escreveu:

Thanks Marcelo. That works great.

Wendy

"Marcelo" wrote in message
...
Hi wendy,

Format as custom £##"."##

hth
regards from Brazil
Marcelo



"Wendy" escreveu:

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






Reply With QuoteReply With Quote