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

[Marcelo]

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
>
>
>

[Wendy]

Thanks Marcelo. That works great.

Wendy

"Marcelo" <[email protected]> wrote in message
news:[email protected]...
> 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
> >
> >
> >

[Marcelo]

thanks for the feedback

regards

"Wendy" escreveu:

> Thanks Marcelo. That works great.
>
> Wendy
>
> "Marcelo" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> > >
> > >
> > >
>
>
>

[Gord Dibben]

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" <[email protected]> wrote in message
>news:[email protected]...
>> 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
>> >
>> >
>> >
>