Convert $ to decimal

anubis

Active Member
Joined
Dec 22, 2004
Messages
359
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
ABCD
1$17,776.0017.8
2$2,345.002.3
3$111,622.00111.6
4$23,452.0023.5
5$35,750.0035.8
6$35,749.0035.7
Sheet1
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
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

Active Member
Joined
Dec 22, 2004
Messages
359
Hey DominicB,

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

Watch MrExcel Video

Forum statistics

Threads
1,113,956
Messages
5,545,181
Members
410,668
Latest member
Gaexel
Top