Convert $ to decimal

[anubis]

Hi all. I have a sheet of dollar values that I need converted to a shorter decimal number. The number needs to be rounded to the nearest hundred and then shown as a decimal. Ie... $22,379 would be converted to 22.4 Below is a range of examples.

As always, any help is appreciated.

Book1
	A	B	C	D
1	$17,776.00	17.8
2	$2,345.00	2.3
3	$111,622.00	111.6
4	$23,452.00	23.5
5	$35,750.00	35.8
6	$35,749.00	35.7
Sheet1

 

[DominicB]

Good evening anubis

Using Ctrl select all the cells that you want to show like this and press Ctrl + 1. In the Number tab select Custom format and in the format box type :

#,##0.0,

HTH

DominicB

 

[anubis]

Hey DominicB,

Nice would have never figured the last comma out. Thank you for the help.