# Thread: Copy values as two decimal points (Excel 2003)

1. ## Copy values as two decimal points (Excel 2003)

I am copying values from one workbook with formulas to another workbook. As an example, the formula on worksheet one calculates 2,828.18 *65.5% =1,852.46. When I copy /paste special/value 1,852.46 to a new workbook, it shows as 1,852.46 but the value in the formula bar is 1,852.4579.

I'm familiar with ROUNDUP and "Precision as displayed" but is there a simpler way to just copy it as two decimals? Thanks.

2. ## Re: Copy values as two decimal points (Excel 2003)

Welcome (back) to Woody's Lounge!

The result of your calculation *is* 1852.4579 even if it is displayed as 1852,46 in the original worksheet. You can verify this by making the column containing the cell with the result wider. So you need to use a rounding function or set Excel to use precision as displayed. Another possibility is to paste the number (displayed with 2 decimal places) into another application, for example Word or Notepad, copy the number in that application and then paste into the other workbook.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•