T
Tiziano
I have this Excel file which is a price list subdivided in many tables
scattered around many worksheets according to product families. Some of the
worksheets have several price tables in them. Figures in price tables are
formatted so that visually one sees only two decimals, but in reality each
figure has many decimals behind it. (The number of decimals varies...)
How do I change things in the workbook so that every figure in every table
of every worksheet truly has only two decimals? This has become a problem
because employees use this workbook as a source of data via ad-hoc links to
other spreadsheets for their calculations and we always end up with numbers
off by a few cents since some use the function =round(number,2) while others
forget to use it, or round to a different number of decimals, when doing
calculations.
I think I can solve the problem by permanently setting each figure in the
source workbook to two decimals but I need a tip on how to do it
efficiently. Right now my choices are to manually go over each figure in
each price table (there are many price tables scattered around many
worksheets, and several worksheets have more than one price table in them!)
and retype it with only two decimals, or use the function =round(number,2)
in an unused portion of each worksheet, table by table, and then do a
Copy->Paste Special->Values and then cutting and pasting the result back in
the original table.
I am hoping that somebody comes up with a more efficient way of doing it
since the nature of the workbook and the different layouts of the price
tables would make all this very time-consuming...
Thanks!!
scattered around many worksheets according to product families. Some of the
worksheets have several price tables in them. Figures in price tables are
formatted so that visually one sees only two decimals, but in reality each
figure has many decimals behind it. (The number of decimals varies...)
How do I change things in the workbook so that every figure in every table
of every worksheet truly has only two decimals? This has become a problem
because employees use this workbook as a source of data via ad-hoc links to
other spreadsheets for their calculations and we always end up with numbers
off by a few cents since some use the function =round(number,2) while others
forget to use it, or round to a different number of decimals, when doing
calculations.
I think I can solve the problem by permanently setting each figure in the
source workbook to two decimals but I need a tip on how to do it
efficiently. Right now my choices are to manually go over each figure in
each price table (there are many price tables scattered around many
worksheets, and several worksheets have more than one price table in them!)
and retype it with only two decimals, or use the function =round(number,2)
in an unused portion of each worksheet, table by table, and then do a
Copy->Paste Special->Values and then cutting and pasting the result back in
the original table.
I am hoping that somebody comes up with a more efficient way of doing it
since the nature of the workbook and the different layouts of the price
tables would make all this very time-consuming...
Thanks!!