+ Reply to Thread
Results 1 to 6 of 6

Data Tables format

  1. #1
    Maria Smith
    Guest

    Data Tables format

    Excel 2000 - my data table is showing in dollars when the source data and
    value axis is formatted in pounds sterling.

  2. #2
    Barb Reinhardt
    Guest

    Re: Data Tables format

    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.




  3. #3
    Maria Smith
    Guest

    Re: Data Tables format

    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.

    >
    >
    >


  4. #4
    Barb Reinhardt
    Guest

    Re: Data Tables format

    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.

    > >
    > >
    > >




  5. #5
    Jon Peltier
    Guest

    Re: Data Tables format

    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.


  6. #6
    Maria Smith
    Guest

    Re: Data Tables format

    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.

    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1