Macro to convert text to number

[Wgmoneill]

Hi Excel Experts,

Macro to convert text to number and format the cell to number without decimal point .00. I have the conversion from text, but cannot incorporate the decimal point.

Any help would be appreciated

William

[oeldere]

You get better help if you post an Excel-file (example of your workbook), without confidential information.

Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

Use BEFORE/AFTER sheets if that helps make it clearer.