remove decimal values

jts2004

Board Regular
Joined
Apr 21, 2004
Messages
156
I have this:

12.1234
13.12345
20.20066

I want to eliminate every decimal number after the 3rd one. I don't want to round up or down. Just delete the extra numbers

12.123
13.123
20.200
 

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Watch MrExcel Video

Forum statistics

Threads
1,109,201
Messages
5,527,383
Members
409,759
Latest member
KCH

This Week's Hot Topics

Top