# Search results

1. ### how to convert text to numbers?

Can anyone help on this?
2. ### how to convert text to numbers?

Wants to convert this text " One thousand and twelve" to 1012.
3. ### How to run column filled data on command prompt from excel?

I have written multiple command in excel in column. how do i run on command prompt?
4. ### Need help for SUMPRODUCT

Hello Haseeb, Thanks a ton... it's working perfect.. Thank you.
5. ### Need help for SUMPRODUCT

I have tried sumproduct formula but there is some mistake.. Please guide me.
6. ### Help for formula please. (remove duplicate and count)

Thanks a lot.. Sir..:)
7. ### Help for formula please. (remove duplicate and count)

(remove duplicate and count)
8. ### Any Opposite formula of CONCATENATE? or Split the cell value in cells?

Thanks Lakshmi Narain. Get the exact what i wanth..:) Thanks a lot..
9. ### Any Opposite formula of CONCATENATE? or Split the cell value in cells?

Maximum number would be 25 (till Z column)
10. ### Any Opposite formula of CONCATENATE? or Split the cell value in cells?

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 Azumi, Thanks a lot.. It is exactly that what i want.. Thank you.:)
12. ### conditional formatting

Hello Ysherriff, Have tried here as my knowledge. Hoping that it can help you. Thanks.

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...
14. ### IF formula doesn't allowed name?

Thanks Dileep, Thanks for your nice suggestion..:)
15. ### IF formula doesn't allowed name?

=IF(C2 = T., 0,1):( name error. Can anyone please guide me?
16. ### Author name protection

How to protect only the author name in excel 2007? I don't want to protect another things in sheet. Please guide me Thanks you all.
17. ### Sum with muliple criteria

Thanks Xiq, It works.. Thanks a lot..:)
18. ### Sum with muliple criteria

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?
19. ### Good Efforts Never fail

Good Efforts Never fail
20. ### Sum with muliple criteria

Hello Friends, Need your help for sum with multiple criteria. It is difficult to describe here. So i have uploaded here excel file.. Thank you all.
21. ### Try hard.. luck is not far..

Try hard.. luck is not far..
22. ### Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

Thanks Narayan, it is working perfectly.. You always help me in need. Salute you.:) Thank you..
23. ### Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

Can anybody help me this.. extreme need for your help.
24. ### Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

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
25. ### Need your help for SUMIF, LEFT, RIGHT with Name criteria [SOLVED]

Hello Hui, Que 1. =&#62; yes. Que 2. =&#62; 2 or 3 rows per date. Que 3. =&#62; yes. Thanks for Responding.