The letter "b" appears after the dollar sign

[Fellow]

I formatted a column as "Accounting" and selected the standard "$"
symbol; the first one on the list.
For some reason the all the affected cells show the letter "b"
immediately following the dollar sign.
If I switch to a regional dollar, say, Canadian, the "b" does not
appear.

Been using Excel for a long time but I've never seen this before.

Any ideas?

 

[Ron Rosenfeld]

I formatted a column as "Accounting" and selected the standard "$"
symbol; the first one on the list.
For some reason the all the affected cells show the letter "b"
immediately following the dollar sign.
If I switch to a regional dollar, say, Canadian, the "b" does not
appear.

Been using Excel for a long time but I've never seen this before.

Any ideas?

For some reason, it appears as if your Accounting selection may be defaulting
to the Bolivian $.

If you right click the cell
Format Cells/Number
Accounting
Check what is in the "Symbol" line
--ron

 

[Fellow]

For some reason, it appears as if your Accounting selection may be defaulting
to the Bolivian $.

If you right click the cell
        Format Cells/Number
        Accounting
                Check what is in the "Symbol" line
--ron

Ron, read my post... I'm selecting the default dollar symbol.

 

[Fellow]

Ron, read my post... I'm selecting the default dollar symbol.

Sorry, that was a bit sharp of me.

 

[Ron Rosenfeld]

Ron, read my post... I'm selecting the default dollar symbol.

I did. There are several ways of selecting the Accounting method and it was
not clear from your post whether you were using the one I described.

What version of Excel?
What country are you in?

Please do the following.

1. Select an affected cell (showing $b)
2. Right click on the cell
Format cells
Number
Custom

Select the contents of the Type: box and paste the results here.

Also, go to

Start/Control Panel/Regional and Language Options
Regional Options tab
What Language (country) shows?
Copy the contents of the currency box and paste the results
here.
--ron

 

[Ron Rosenfeld]

Sorry, that was a bit sharp of me.

OK
--ron

 

[Fellow]

I did.  There are several ways  of selecting the Accounting method and it was
not clear from your post whether you were using the one I described.

What version of Excel?
What country are you in?

Please do the following.

1.  Select an affected cell (showing $b)
2.  Right click on the cell
        Format cells
        Number
        Custom

        Select the contents of the Type: box and paste the results here.

Also, go to

Start/Control Panel/Regional and Language Options
        Regional Options tab
                What Language (country) shows?
                Copy the contents of the currency box andpaste the results
here.
--ron

Well, I'll be!
I started Excel again and now the problem is gone...
If it starts up again I'll paste the custom format in here like you
asked.

In any case, my region was set to USA (oops— new computer) and is now
set to Canada (Ahhhh, better). The currency is set correctly in either
case.

Thanks for your help!

 

[Ron Rosenfeld]

Well, I'll be!
I started Excel again and now the problem is gone...
If it starts up again I'll paste the custom format in here like you
asked.

In any case, my region was set to USA (oops— new computer) and is now
set to Canada (Ahhhh, better). The currency is set correctly in either
case.

Thanks for your help!

Well, the format you described "$b" is one that is used by Excel. The
question was how it got there. Obviously a moot point for now.

Glad it's working.
--ron