+ Reply to Thread
Results 1 to 8 of 8

Euro symbol not appearing when formatted to do so

  1. #1
    liz
    Guest

    Euro symbol not appearing when formatted to do so

    When i format cells to show the € symbol in the currency format it appears as
    a| instead, can anyone explain why this is happening, it happened even when i
    opened the document on another pc.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Liz,

    You can format the cell as

    "€ "#,##0.00;[Red]-" € "#,##0.00

    which should show as you would wish it to.





    Quote Originally Posted by liz
    When i format cells to show the € symbol in the currency format it appears as
    a| instead, can anyone explain why this is happening, it happened even when i
    opened the document on another pc.

  3. #3
    liz
    Guest

    Re: Euro symbol not appearing when formatted to do so

    When i do that the whole number appears as #####, i ended up being able to
    fomat the cells individually but i had to put the size at 75% if i put it to
    50% the euro symbol goes back to a | sign, i even tried reinstalling excel.

    "Bryan Hessey" wrote:

    >
    > Liz,
    >
    > You can format the cell as
    >
    > "€ "#,##0.00;[Red]-" € "#,##0.00
    >
    > which should show as you would wish it to.
    >
    >
    >
    >
    >
    > liz Wrote:
    > > When i format cells to show the € symbol in the currency format it
    > > appears as
    > > a| instead, can anyone explain why this is happening, it happened even
    > > when i
    > > opened the document on another pc.

    >
    >
    > --
    > Bryan Hessey
    > ------------------------------------------------------------------------
    > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > View this thread: http://www.excelforum.com/showthread...hreadid=466179
    >
    >


  4. #4
    Dave Peterson
    Guest

    Re: Euro symbol not appearing when formatted to do so

    When you see a cell with a number that's showing ####, it's usually because the
    column isn't wide enough.

    You could try widening the columnwidth or making the font smaller.

    liz wrote:
    >
    > When i do that the whole number appears as #####, i ended up being able to
    > fomat the cells individually but i had to put the size at 75% if i put it to
    > 50% the euro symbol goes back to a | sign, i even tried reinstalling excel.
    >
    > "Bryan Hessey" wrote:
    >
    > >
    > > Liz,
    > >
    > > You can format the cell as
    > >
    > > "€ "#,##0.00;[Red]-" € "#,##0.00
    > >
    > > which should show as you would wish it to.
    > >
    > >
    > >
    > >
    > >
    > > liz Wrote:
    > > > When i format cells to show the € symbol in the currency format it
    > > > appears as
    > > > a| instead, can anyone explain why this is happening, it happened even
    > > > when i
    > > > opened the document on another pc.

    > >
    > >
    > > --
    > > Bryan Hessey
    > > ------------------------------------------------------------------------
    > > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > > View this thread: http://www.excelforum.com/showthread...hreadid=466179
    > >
    > >


    --

    Dave Peterson

  5. #5
    liz
    Guest

    Re: Euro symbol not appearing when formatted to do so

    Thanks Dave, i soreted that problem but i still have the problem of the
    document going back to the | sign instead of the € sign when i take the page
    size off 75%

    "Dave Peterson" wrote:

    > When you see a cell with a number that's showing ####, it's usually because the
    > column isn't wide enough.
    >
    > You could try widening the columnwidth or making the font smaller.
    >
    > liz wrote:
    > >
    > > When i do that the whole number appears as #####, i ended up being able to
    > > fomat the cells individually but i had to put the size at 75% if i put it to
    > > 50% the euro symbol goes back to a | sign, i even tried reinstalling excel.
    > >
    > > "Bryan Hessey" wrote:
    > >
    > > >
    > > > Liz,
    > > >
    > > > You can format the cell as
    > > >
    > > > "€ "#,##0.00;[Red]-" € "#,##0.00
    > > >
    > > > which should show as you would wish it to.
    > > >
    > > >
    > > >
    > > >
    > > >
    > > > liz Wrote:
    > > > > When i format cells to show the € symbol in the currency format it
    > > > > appears as
    > > > > a| instead, can anyone explain why this is happening, it happened even
    > > > > when i
    > > > > opened the document on another pc.
    > > >
    > > >
    > > > --
    > > > Bryan Hessey
    > > > ------------------------------------------------------------------------
    > > > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > > > View this thread: http://www.excelforum.com/showthread...hreadid=466179
    > > >
    > > >

    >
    > --
    >
    > Dave Peterson
    >


  6. #6
    liz
    Guest

    Re: Euro symbol not appearing when formatted to do so

    Actually guys , I have it sorted now, it really is just to do with the page
    size. I dont know why but hey!! I'll just have to leave the page size to
    anything above 50%!!!
    Cheers!!

    "liz" wrote:

    > Thanks Dave, i soreted that problem but i still have the problem of the
    > document going back to the | sign instead of the € sign when i take the page
    > size off 75%
    >
    > "Dave Peterson" wrote:
    >
    > > When you see a cell with a number that's showing ####, it's usually because the
    > > column isn't wide enough.
    > >
    > > You could try widening the columnwidth or making the font smaller.
    > >
    > > liz wrote:
    > > >
    > > > When i do that the whole number appears as #####, i ended up being able to
    > > > fomat the cells individually but i had to put the size at 75% if i put it to
    > > > 50% the euro symbol goes back to a | sign, i even tried reinstalling excel.
    > > >
    > > > "Bryan Hessey" wrote:
    > > >
    > > > >
    > > > > Liz,
    > > > >
    > > > > You can format the cell as
    > > > >
    > > > > "€ "#,##0.00;[Red]-" € "#,##0.00
    > > > >
    > > > > which should show as you would wish it to.
    > > > >
    > > > >
    > > > >
    > > > >
    > > > >
    > > > > liz Wrote:
    > > > > > When i format cells to show the € symbol in the currency format it
    > > > > > appears as
    > > > > > a| instead, can anyone explain why this is happening, it happened even
    > > > > > when i
    > > > > > opened the document on another pc.
    > > > >
    > > > >
    > > > > --
    > > > > Bryan Hessey
    > > > > ------------------------------------------------------------------------
    > > > > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > > > > View this thread: http://www.excelforum.com/showthread...hreadid=466179
    > > > >
    > > > >

    > >
    > > --
    > >
    > > Dave Peterson
    > >


  7. #7
    Dave Peterson
    Guest

    Re: Euro symbol not appearing when formatted to do so

    Excel substitutes fonts when the zoom factor is small (I don't recall what small
    is).

    Maybe this post by Debra Dalgleish will help:

    You can change a registry setting to prevent this from happening (make a
    backup copy of the registry first):

    1. From the Start button, choose Run
    2. Type regedit then click OK
    3. Click the + sign to the left of HKEY_CURRENT_USER
    4. Open Software, Microsoft, Office, 9.0, Excel, Options
    5. Choose Edit>New>DWORD Value
    6. Type the name for the DWORD: FontSub
    7. Press Enter to complete the renaming
    8. Choose Edit>Modify
    9. Type 0 as the value, select Decimal, and click OK
    10. Close the Registry Editor

    =====
    That 9.0 will vary with your version of excel.

    liz wrote:
    >
    > Actually guys , I have it sorted now, it really is just to do with the page
    > size. I dont know why but hey!! I'll just have to leave the page size to
    > anything above 50%!!!
    > Cheers!!
    >
    > "liz" wrote:
    >
    > > Thanks Dave, i soreted that problem but i still have the problem of the
    > > document going back to the | sign instead of the € sign when i take the page
    > > size off 75%
    > >
    > > "Dave Peterson" wrote:
    > >
    > > > When you see a cell with a number that's showing ####, it's usually because the
    > > > column isn't wide enough.
    > > >
    > > > You could try widening the columnwidth or making the font smaller.
    > > >
    > > > liz wrote:
    > > > >
    > > > > When i do that the whole number appears as #####, i ended up being able to
    > > > > fomat the cells individually but i had to put the size at 75% if i put it to
    > > > > 50% the euro symbol goes back to a | sign, i even tried reinstalling excel.
    > > > >
    > > > > "Bryan Hessey" wrote:
    > > > >
    > > > > >
    > > > > > Liz,
    > > > > >
    > > > > > You can format the cell as
    > > > > >
    > > > > > "€ "#,##0.00;[Red]-" € "#,##0.00
    > > > > >
    > > > > > which should show as you would wish it to.
    > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > > > > liz Wrote:
    > > > > > > When i format cells to show the € symbol in the currency format it
    > > > > > > appears as
    > > > > > > a| instead, can anyone explain why this is happening, it happened even
    > > > > > > when i
    > > > > > > opened the document on another pc.
    > > > > >
    > > > > >
    > > > > > --
    > > > > > Bryan Hessey
    > > > > > ------------------------------------------------------------------------
    > > > > > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > > > > > View this thread: http://www.excelforum.com/showthread...hreadid=466179
    > > > > >
    > > > > >
    > > >
    > > > --
    > > >
    > > > Dave Peterson
    > > >


    --

    Dave Peterson

  8. #8
    liz
    Guest

    Re: Euro symbol not appearing when formatted to do so

    Thanks Dave!!

    "Dave Peterson" wrote:

    > Excel substitutes fonts when the zoom factor is small (I don't recall what small
    > is).
    >
    > Maybe this post by Debra Dalgleish will help:
    >
    > You can change a registry setting to prevent this from happening (make a
    > backup copy of the registry first):
    >
    > 1. From the Start button, choose Run
    > 2. Type regedit then click OK
    > 3. Click the + sign to the left of HKEY_CURRENT_USER
    > 4. Open Software, Microsoft, Office, 9.0, Excel, Options
    > 5. Choose Edit>New>DWORD Value
    > 6. Type the name for the DWORD: FontSub
    > 7. Press Enter to complete the renaming
    > 8. Choose Edit>Modify
    > 9. Type 0 as the value, select Decimal, and click OK
    > 10. Close the Registry Editor
    >
    > =====
    > That 9.0 will vary with your version of excel.
    >
    > liz wrote:
    > >
    > > Actually guys , I have it sorted now, it really is just to do with the page
    > > size. I dont know why but hey!! I'll just have to leave the page size to
    > > anything above 50%!!!
    > > Cheers!!
    > >
    > > "liz" wrote:
    > >
    > > > Thanks Dave, i soreted that problem but i still have the problem of the
    > > > document going back to the | sign instead of the € sign when i take the page
    > > > size off 75%
    > > >
    > > > "Dave Peterson" wrote:
    > > >
    > > > > When you see a cell with a number that's showing ####, it's usually because the
    > > > > column isn't wide enough.
    > > > >
    > > > > You could try widening the columnwidth or making the font smaller.
    > > > >
    > > > > liz wrote:
    > > > > >
    > > > > > When i do that the whole number appears as #####, i ended up being able to
    > > > > > fomat the cells individually but i had to put the size at 75% if i put it to
    > > > > > 50% the euro symbol goes back to a | sign, i even tried reinstalling excel.
    > > > > >
    > > > > > "Bryan Hessey" wrote:
    > > > > >
    > > > > > >
    > > > > > > Liz,
    > > > > > >
    > > > > > > You can format the cell as
    > > > > > >
    > > > > > > "€ "#,##0.00;[Red]-" € "#,##0.00
    > > > > > >
    > > > > > > which should show as you would wish it to.
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > liz Wrote:
    > > > > > > > When i format cells to show the € symbol in the currency format it
    > > > > > > > appears as
    > > > > > > > a| instead, can anyone explain why this is happening, it happened even
    > > > > > > > when i
    > > > > > > > opened the document on another pc.
    > > > > > >
    > > > > > >
    > > > > > > --
    > > > > > > Bryan Hessey
    > > > > > > ------------------------------------------------------------------------
    > > > > > > Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
    > > > > > > View this thread: http://www.excelforum.com/showthread...hreadid=466179
    > > > > > >
    > > > > > >
    > > > >
    > > > > --
    > > > >
    > > > > Dave Peterson
    > > > >

    >
    > --
    >
    > Dave Peterson
    >


+ 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