Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Number to Tex in Excel 2007

Number to Tex in Excel 2007

    Then, Microsoft Visual Basic Window opens


1Open MS Excel Workbook


2. Click Alt + F11


    Then, Microsoft Visual Basic Window opens3. Click Alt + I, M (or Click Module from Insert Menu Bar)    Then, Module Window opens


4. Copy the below Code (Short Cut: Ctrl + C (or) Alt + E, C (or) Right Click, C (or) Ctrl + Insert)




3. Click Alt + I, M (or Click Module from Insert Menu Bar)
    Then, Module Window opens

4. Copy the below Code (Short Cut: Ctrl + C (or) Alt + E, C (or) Right Click, 

C (or) Ctrl + Insert)

5. Paste into the Module Window (Short Cut: Ctrl + V (or) Alt + E, V (or) Right Click, V)
  
6. Close Microsoft Visual Basic Window

7. =numwords(100)