Hello Friends,
Need small help from your side.
I have value 9 in cell A1,
now i need 9 zeros in Cell from B1 to Z1.
I'll have to change the value in A column and it is maximum till 25. So i no need to use more columns after column Z.
If i write 5 in A2 then the result would be in B2 to F2 = 0...
Hello Friends,
I have checked the below given link
http://chandoo.org/forum/threads/how-convert-number-to-text-in-excel.12009/
I get the nearest result. But actually i wants to teach my boy. I don't want "Rupees only" or"Paisa" at last..
and
If Possible I would also like to convert Spell to...
Hello Xiq,
Your efforts are too good but "helper column" extend my efforts a lot..
Total time spent v1 & v2 is also good..
Can't we skip the helper column?
Thanks Hui.. It is working fine. but little bit problem,
When there is file name contain N.jpg then the value should be in F row (F2) blank or zero. Cause it is added in T.jpg