Change number formating

[Wendy]

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

 

[Guest]

Hi wendy,

Format as custom £##"."##

hth
regards from Brazil
Marcelo



"Wendy" escreveu:

 

[Wendy]

Thanks Marcelo. That works great.

Wendy

Hi wendy,

Format as custom £##"."##

hth
regards from Brazil
Marcelo



"Wendy" escreveu:

 

[Guest]

thanks for the feedback

regards

"Wendy" escreveu:

 

[Gord Dibben]

Wendy

Just remember, the number is still 1000 if you're doing any calculations.


Gord Dibben MS Excel MVP