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.

Liz,

You can format the cell as

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

which should show as you would wish it to.

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.

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

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

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
>

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