Canadian Currency format

  • Thread starter Thread starter Lynn
  • Start date Start date
L

Lynn

I want to display a C in front of my monetary values to
indicate Canadian currency. Can I do this WITHOUT
creating a custom format? ie. Is it not a built in format
option?
 
Lynn,

If you format a cell using Format - Cells - Number Custom you can easily
copy it to other cells with the Format Painter (standard toolbar). Or we
can give you a macro which you can activate with a custom button or a
keyboard shortcut to accomplish it.

I don't know what it's supposed to look like with that C, but if you give
some examples, we can give you some format codes. One approach would be to
first use a built-in US format, changing the appropriate parts to change the
$ to C.
 
Lynn

Try Format>Cells>Currency. Scroll down in the "symbol" dialog box to
C$(Spanish - Nicaragua). Probably the closest you can get without Custom
Format.

Gord Dibben Excel MVP
 
Lynn

Try Format>Cells>Currency. Scroll down in the "symbol" dialog box to
C$(Spanish - Nicaragua). Probably the closest you can get without Custom
Format.
Click to expand...

If you scroll down further, you find CAD, which is the usual abbreviation
for the Canadian Dollar. Personally, I would use the C$ if the context is
clear.
 
Missed the CAD completely.

Thanks for the point, Jay.
Click to expand...

My pleasure. I actually leaned something here too -- I had never scrolled
down the symbol list before -- I had no idea what was there. Your question
triggered a useful investigation. The thanks are mutual!
 
Back
Top