View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default The letter "b" appears after the dollar sign

On Tue, 5 Aug 2008 20:59:22 -0700 (PDT), Fellow wrote:

On Aug 5, 11:58*pm, Fellow wrote:
On Aug 5, 2:28*pm, Ron Rosenfeld wrote:



On Tue, 5 Aug 2008 09:59:31 -0700 (PDT), Fellow wrote:
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


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


Sorry, that was a bit sharp of me.


OK
--ron