I am formatting data in an excel worksheet that will eventually be exported into a database. I have a column of numbers that are for example 0.002563589623. I need to shorten those to 0.0026. When I use the format number option, it appears to be correct but in the formula bar it appears as original. Is there a simple way to shorten the number completely without retyping the entire 14,000 cells?