Sometimes we need to convert a Number into Word in Microsoft Excel. But Excel Does not provide inbuilt function to do this.
But here is solution for this. You can create your own Function N2S to convert Number to Word.
For More Detail Click H...
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Thursday, 4 October 2012
Monday, 1 October 2012
75 Super Excel Magic
25 Very Useful Keyboard Shortcuts
1. To format any selected object, press ctrl+1
2. To insert current date, press ctrl+;
3. To insert current time, press ctrl+shift+;
4. To repeat last action, press F4
5. To edit a cell comment, press shift + F2
6. To autosum selected cells, press alt + =
7. To see the suggest drop-down in a cell, press alt + down arrow
8. To enter multiple lines in a cell, press alt+enter
9. To insert a new sheet, press shift...
Posts
