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.
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 |