close

In Excel 2003, I would like to change the Dollar ($) sign style to Dirhams
(Dhs.) sign style and I really don't know how to do it.Please help me.Thank
you very much.


Click Format, then click Cells. Select custom from the bottom.

Select the fomat you prefer with the $ symbol. Change the $ symbol to
the Dirhams symbol...from what I can tell, it looks kind of like this
#9674;.

I tried it in my version of Excel and it worked in placing a #9674; in
front of numbers instead of a dollar sign. If the Dirhams symbol needs
to go at the back, just move the placement of the symbol in the custom
format screen.--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: www.excelforum.com/member.php...oamp;userid=28611
View this thread: www.excelforum.com/showthread...hreadid=529019I did receive/read your response to my question but sad to say that it won't
work to my Excel 2003/XP Home.Perhaps I am naive with regards to excel that
is why I didn't follow you well your instructions.Anyway, what I did are the
following and I am begging to please send me a reply wether I did the wrong
way and I thank you in advance and may your tribe increase:I click Cell
wherein the $56.00 which I want to change to Dhs.56.00, click Format, click
Custom from the bottom and I changed all the dollar ($) on it to â—Š and I
click OK but nothing happened.Your help will be highly appreciated if you
will tell me the step-by-step on how to do it please.Thank you once again.

quot;Lotus123quot; wrote:

gt;
gt; Click Format, then click Cells. Select custom from the bottom.
gt;
gt; Select the fomat you prefer with the $ symbol. Change the $ symbol to
gt; the Dirhams symbol...from what I can tell, it looks kind of like this
gt; â—Š.
gt;
gt; I tried it in my version of Excel and it worked in placing a â—Š in
gt; front of numbers instead of a dollar sign. If the Dirhams symbol needs
gt; to go at the back, just move the placement of the symbol in the custom
gt; format screen.
gt;
gt;
gt; --
gt; Lotus123
gt; ------------------------------------------------------------------------
gt; Lotus123's Profile: www.excelforum.com/member.php...oamp;userid=28611
gt; View this thread: www.excelforum.com/showthread...hreadid=529019
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()