LinkBack URL
About LinkBacks
hi frnds.. i want to converting number to word
hi frnds.. i want to converting number to word
What with decimal numbers?
like 19,798.15
Never use Merged Cells in Excel
ya dat also.Originally Posted by Shilpa kanchan
=spellnumber(p21)
If I helped, please don't forget to add to my reputation. (click on the star below the post)
If the problem is solved, please: Select Thread Tools (on top of your 1st post) -> Mark this thread as Solved.
Failure is not falling down but refusing to get up.
Here, try this:
see it's not working
My answer does
In E22 input =spellnumber(p21)
no it's not working
What's not working.. From your attachment: `19.798,50 is
Nineteen Thousand Seven Hundred Ninety Eight Point 50
see the Exmpl file wat i attached last. it's not point 10, nineteen thousand seven hundred ninety eight & fifty paise only.. it luks lik dis.
I've asked you:
What with decimal numbers?
like 19,798.15
and you answered:
ya dat also.
So what is it then?
What's wrong with this?
it not point fifty, fifty paise only.
if i change the value, i wnt be changed na.. it shws error.
if i change the value, it'l b error.
please don't use slang or text speech I'm sure your grasp of the English language is better than that.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
o god, just chang the value in p4 it wil be error na..
I don't get error when changing values in P column.
no is there to help me
Not unless you tell us what's not working...
Try to be more descriptive. Don't assume anyone is familiar with your problem. While you can upload small attachments, describe your problem in the body of the post. We are fortunate to have several Excel gurus, but few mind-readers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks