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

Change number formating
 

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

Change number formating
 

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

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

Change number formating
 

Wendy

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


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 15:25:42 +0100, "Wendy" <Wendy @sunnygirl.com wrote:

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