Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a letter in Excell with double strikethrough N?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a letter in Excell with double strikethrough N?
If there's a better way in Excel, I'm not aware of it, but here is what I
got...:) Select a blank cell On the Insert menu select Symbol On the Symbol dialog box select the Symbol tab Select Tahoma from the Font dropdown, then select Currency Symbols from the Subset drop down (you should now see the Nigerian Naira currency symbol in the list of symbols below) Click on the Insert button Highlight and then copy the symbol (just the symbol/text, don't copy the cell) Select the cells that contain the values you want to format with the Nigerian Naira currency symbol On the Format menu select Cell On the Format Cell dialog box, select the Numbers tab From the Category list box, select custom In the Type text box paste the Nigerian Naira currency symbol (Ctrl+v) Type the followin after the symbol in the Type text box, " #.00" (without qoutes) The final Custom format should look like this, "‚¦ #.00" (without qoutes) Harder to type than to do.;) Apply the custom format to any value that requires it!! -- Hope this Helps! Camilo Objective: To help one person each day! Feedback is greatly appreciated! Please let me know if I've answered your question or if my post was helpful to you? "jt19373" wrote: How do I format the character N with a double strikethrough as a currency symbol for Nigeria? EG: N1,000.00 . The N in N1,000.00 is displayed with a double strike through? please reply to |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format a letter in Excell with double strikethrough N?
There are Arial MS unicode symbols for nearly all currencies. See:
http://www.xe.com/symbols.htm ‚¦ ‚¦ 8358 20A6 are the decimal and hex unicodes -- Gary''s Student "jt19373" wrote: How do I format the character N with a double strikethrough as a currency symbol for Nigeria? EG: N1,000.00 . The N in N1,000.00 is displayed with a double strike through? please reply to |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to format a date to a different format | Excel Discussion (Misc queries) | |||
protecting format | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Letter format | Excel Discussion (Misc queries) | |||
When I select "format cells", the format dialog box does not disp. | Excel Worksheet Functions |