View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Auric__ Auric__ is offline
external usenet poster
 
Posts: 538
Default Conversion from Number to Word!! Aki

Akash wrote:

I have the below mentioned code. I have a Number as 501123.83 in a
cell (E2).

If I put =spellNumber(E2)

It is giving me a value as
RUPEES FIVE HUNDRED ONE THOUSAND ONE HUNDRED THIRTY THREE AND EIGHTY
THREE PAISE ONLY

I wanted a value as below:

RUPEES FIVE LAKHS ONE THOUSAND ONE HUNDRED THIRTY THREE AND EIGHTY
THREE PAISE ONLY


Just a thought -- you could perhaps use some variation of the code he
http://rosettacode.org/wiki/Number_names#Visual_Basic

--
You feared of phantoms, and none exists but you.