Excel 2000 - my data table is showing in dollars when the source data and
value axis is formatted in pounds sterling.
Excel 2000 - my data table is showing in dollars when the source data and
value axis is formatted in pounds sterling.
I believe all you need to do is change the format for that column from $ to
the correct currency. Use the FORMAT CELLS command, select CURRENCY and
select the appropriate symbol.
"Maria Smith" <Maria [email protected]> wrote in message
news:[email protected]...
> Excel 2000 - my data table is showing in dollars when the source data and
> value axis is formatted in pounds sterling.
Thanks Barb but it is not possible to do that on the data in a data table in
a chart: it takes it format from the underlying source data which is pounds
sterling. This is why i can't understand why it is showing in dollars -
weird.
"Barb Reinhardt" wrote:
> I believe all you need to do is change the format for that column from $ to
> the correct currency. Use the FORMAT CELLS command, select CURRENCY and
> select the appropriate symbol.
> "Maria Smith" <Maria [email protected]> wrote in message
> news:[email protected]...
> > Excel 2000 - my data table is showing in dollars when the source data and
> > value axis is formatted in pounds sterling.
>
>
>
I didn't realize it was on the chart. I wish I could help you.
"Maria Smith" <[email protected]> wrote in message
news:[email protected]...
> Thanks Barb but it is not possible to do that on the data in a data table
in
> a chart: it takes it format from the underlying source data which is
pounds
> sterling. This is why i can't understand why it is showing in dollars -
> weird.
>
> "Barb Reinhardt" wrote:
>
> > I believe all you need to do is change the format for that column from $
to
> > the correct currency. Use the FORMAT CELLS command, select CURRENCY and
> > select the appropriate symbol.
> > "Maria Smith" <Maria [email protected]> wrote in message
> > news:[email protected]...
> > > Excel 2000 - my data table is showing in dollars when the source data
and
> > > value axis is formatted in pounds sterling.
> >
> >
> >
Maria -
I can't help either. My machine knows to use $ for currency here in the
States, but when I overruled it with a number format that had the pounds
symbol, the data table reflected the pounds symbol.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Maria Smith wrote:
> Excel 2000 - my data table is showing in dollars when the source data and
> value axis is formatted in pounds sterling.
Thanks Jon - it is strange - i have never seen this before in 7 years of
using Excel and am clueless as to why it is happening. The only thing i can
do is do away with the currency format completely but it still intrigues!
"Jon Peltier" wrote:
> Maria -
>
> I can't help either. My machine knows to use $ for currency here in the
> States, but when I overruled it with a number format that had the pounds
> symbol, the data table reflected the pounds symbol.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Maria Smith wrote:
>
> > Excel 2000 - my data table is showing in dollars when the source data and
> > value axis is formatted in pounds sterling.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks