Hello Group,
Column A is a series of prices. Column B is the result I am looking for.
When you click in column A several decimal places come up. I only want two to show rounded.
Formatting in excel does not do what I want and someone gave me this formula with instructions that does not seem to function.
In the first cell of your new column add so lets assume you are copying/converting data from column A, in the new column B add:
=TEXT(A1,”0.00”)
Then copy down the whole length of the document. This will give you the numbers in a 3 digit form without rounding up……but it will still have a formula, so you need to them insert another column. Then copy the whole new column B with the formula you just made, and paste, when you paste the whole column with excel it will ask you special paste, and you choose VALUES. Then without un-highlighting the column it will say error, format ! when you hit the options it will say values. Click values, you need to spot check the document, you will see your final column will only have 0.00 values in number no rounding, no formulas. You can then delete your other 2 columns.
Bookmarks