Currency figures to Text

[Salamullah]

Can anybody help me to convert currency figures into text for exampleSAR 810/=How can I apply formula so it will give me automatically the following :SAR Eight Hundred Ten Onlyp.s SAR means Saudi Arab Riyal.

 

[GlennUK]

This is a good starting point .... tweak it to your needs:

http://support.microsoft.com/kb/213360

 

[Salamullah]

Thanks GlennUK its working

But when I apply this in other worksheet is it showing following error

<TABLE style="WIDTH: 82pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=109 border=0 x:str><COLGROUP><COL style="WIDTH: 82pt; mso-width-source: userset; mso-width-alt: 3986" width=109><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 82pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=middle width=109 height=17 x:err="#NAME?">#NAME?</TD></TR></TBODY></TABLE>

What I am missing ?

 

[GlennUK]

Does this help:

http://support.microsoft.com/kb/213645
?