MS Excel Currency symbols

[SpaceBadger]

Anybody happen to know if there is a way I can tell Excel that for this particular workbook, I want to use Cr as the currency symbol instead of $?

I'm pretty sure this can be done for other actual currencies like pounds, yen, or Euro, but what about Cr for Credits?

 

[CosmicGamer]

One way to have Excel use a different currency symbol is to change it in your computers Regional Options. Sorry, don't have Excel on this computer to see how/if it can be done within the program.

 

[SpaceBadger]

One way to have Excel use a different currency symbol is to change it in your computers Regional Options. Sorry, don't have Excel on this computer to see how/if it can be done within the program.

Thanks, I will have a look at that, but I want to make sure I am only changing it for this one Excel workbook, not as a general default. (Most of the time I live w $, not Cr!)

 

[Fritz_Brown]

You can't set it for an entire workbook, so far as I know, SB, but you can make it a cell format, and apply it to all of your appropriate cells.

Hold on, let me pull up Excel.........

Whichever version you're using, pick a cell where this will apply and go to "Format cell -> Numbers".
Choose a normal currency, and set your parameters of using a thousands separator and how many decimal places you want to use, then click OK.
Now return to "Format cells -> Numbers", and select custom. The format will load in the "Type" box.
Replace the regular currency symbol with "Cr" (no quotes), then click OK. (It will put a "\" between the C and the r for some reason in the format, but that won't show up in your cell.)

If you want the symbol on the other side, simply type it there when you do the replacement of the regular currency symbol.

Now, any time you want to apply it within that workbook, simply highlight the appropriate cells, and apply that custom (it will be at the bottom of the list) format.

It will look like this: C\r#,##0.00

 

[SpaceBadger]

Sigh. I found a setting in the workbook to let me choose from many MANY different currency symbols, but it would not let me substitute one of my own design. About the closest that I saw to Cr was to either use the Euro (not very close at all, really) or the C$ (which I think was a Nicaraguan peso or something).

Or I could just leave it at $ and say they are Cr, sorta like GURPS.

 

[SpaceBadger]

You can't set it for an entire workbook, so far as I know, SB, but you can make it a cell format, and apply it to all of your appropriate cells.

Hold on, let me pull up Excel.........

Whichever version you're using, pick a cell where this will apply and go to "Format cell -> Numbers".
Choose a normal currency, and set your parameters of using a thousands separator and how many decimal places you want to use, then click OK.
Now return to "Format cells -> Numbers", and select custom. The format will load in the "Type" box.
Replace the regular currency symbol with "Cr" (no quotes), then click OK. (It will put a "\" between the C and the r for some reason in the format, but that won't show up in your cell.)

If you want the symbol on the other side, simply type it there when you do the replacement of the regular currency symbol.

Now, any time you want to apply it within that workbook, simply highlight the appropriate cells, and apply that custom (it will be at the bottom of the list) format.

It will look like this: C\r#,##0.00

OK, thanks, will try that later... brain tired now, and I have to go in two hours to help a neighbor whose two heifers got into my herd...

 

[CosmicGamer]

Now that I'm at a computer with Excel, you can go to Format then Style and make changes there.

 

[Fritz_Brown]

True that you could edit a style. If you make it global, then you could use it anytime you want. But if all you want to change is the currency symbol, changing it just in the cell formatting means you have less chance of dorking something up that will haunt you.

 

[MikeinBallard]

Imperial Credit Currency Symbol?

Fritz_Brown has the answer. I was also wondering if there is a combined "Cr" symbol. Looking through the Character Map in Win7, I see there is the Cruzeiro ('Cross' in Brazilian Portuguese), symbolized by '₢' HTML: ₢). Brazil used it 3 times (Hey, three times? Where have we heard that?) until they finalized on the Brazilian Real. The cruzeiro symbol is not currently used, so it might be a candidate.

http://en.wikipedia.org/wiki/Brazilian_cruzeiro