Can't format these numbers

[tigerzen]

This was downloaded from a file at work. I've used CLEAN and a range of techniques to try and convert from text to numbers but nothing has worked. I'd like to format these cells in Currency format.

Support staff model.xlsm
	M
8	58,566
9	59,729
10	60,982
11	61,649
12	62,877
Sheet1

 

[Dave Patton]

Thanks for the feedback.
With substitute and other alternatives, removing the extraneous characters is part of the solution.
The text still must be coerced to a number.

T202409a.xlsm
	M	N	O	P
8	58,566	$58,566.00	$58,566.00	$58,566.00
9	59,729	$59,729.00	$59,729.00	$59,729.00
10
5c

Cell Formulas
Range	Formula
N8:N9	N8	=--CONCAT(TEXTSPLIT(M8,{" ",","}))
O8:O9	O8	=--(LEFT(M8,2)&MID(M8,4,99))
P8:P9	P8	=--SUBSTITUTE(M8,",","",1)

 

[RoryA]

my computer doesn't have a keypad

You could also just copy one of the characters from the end of one of the cells.

 

[felixstraube]

Can you share the file or a sample with the data with problems? (upload to cloud storage and share the link?)

 

[tigerzen]

Can you share the file or a sample with the data with problems? (upload to cloud storage and share the link?)

Hi Felix, is there a particular platform that works well with MrExcel?

 

[felixstraube]

It can be any cloud storage. As long as it is a public link there should be no problem.