Change number formating

W

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
 
M

Marcelo

Hi wendy,

Format as custom £##"."##

hth
regards from Brazil
Marcelo



"Wendy" escreveu:
 
G

Gord Dibben

Wendy

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


Gord Dibben MS Excel MVP
 
Top