Follow these steps to change the numerical format applied to particular cells:
1. Select the special process "[108] (*.XLS) Change Number Format (e.g. add/remove commas)" from the Special Process drop down list. The file format is automatically set as *.XLS.
2. Next select the input and output files. If the output file is the same as the input file, the formatting on the input sheet will be changed. If the output file doesn't exist, 'Convert XLS' will create it along with a copy of the input workbook including the reformatted sheet.
3. Click the Click Here for Change # Format Details button.
a. Sheet to be reformatted must already exist.
b. Specify specific cells to be reformatted or leave it blank to reformat the entire worksheet.
c. Select a new format to be applied from the dropdown list.
4. Optional: Click the Add (or ALT+A) button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 4 as necessary.
5. Click the Convert (or F5) button to execute the process.
Note: If you name a sheet with numbers only, you will need to use quote marks around that name. For example, if you name a sheet 32, when you specify the Input Sheet you must specify "32" with the quotes around the name so Convert XLS knows it is a name and not an index number for the sheet. If you browse for the file and click to select it, you will still need to manually add the quotes.