How to convert text '$1,200.01' to numeric value '1200.01

[Mleeds]

I have a whole column with hundreds of numbers in that text format which I need to sum but I can't because it's in text format. So how do I convert it to numeric values. Thanks.

 

[Mleeds]

Typo 'Excel chart' should be 'Excel cell'.

 

[Mleeds]

Rick, that hunch is exactly right. Thanks. I'll try it again the new version of your formula (which includes the SUBSTITUE function). I'll also try and see if I can get the tools for posting graphics to work for me. -m

 

[Mleeds]

Dave3009, I checked the link to HTML Maker. does HTML Maker work for Excel 2013? Are there instructions for using it with Windows 7 or Windows 10? Thanks.

 

[dave3009]

Dave3009, I checked the link to HTML Maker. does HTML Maker work for Excel 2013? Are there instructions for using it with Windows 7 or Windows 10? Thanks.

It's a tool developed by the board so I'm sure it'll be bang up to date, in Ricks signature block there is also a link to instructions on use. It's very simple really