Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jt19373
 
Posts: n/a
Default How do I format a letter in Excell with double strikethrough N?

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Camilo
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to format a date to a different format Laura Excel Discussion (Misc queries) 1 March 5th 05 10:59 PM
protecting format Esmerelda Excel Discussion (Misc queries) 1 February 25th 05 01:53 PM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 8th 04 12:02 AM
Letter format Ratowl Excel Discussion (Misc queries) 3 December 5th 04 01:23 AM
When I select "format cells", the format dialog box does not disp. Andy S. Excel Worksheet Functions 2 November 23rd 04 04:49 AM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"