View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lotus123
 
Posts: n/a
Default From Dollar ($) sign style to Dirhams (Dhs.) sign style


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
◊.

I tried it in my version of Excel and it worked in placing a ◊ 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: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=529019