Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
Q. How can I apply the same formatting to every sheet in an Excel workbook? A. Applying the same formatting to each sheet in an Excel workbook is ideal when each of your sheets is set up the same, but ...