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
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
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
>
>
>
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
> >
> >
> >
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
> > >
> > >
> > >
>
>
>
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
>> >
>> >
>> >
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks