rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an entire spreadsheet that I have completed the "Copy" "Paste Special - values". I now need the values (not the display number) rounded to the 2nd decimal place. Any tips? Thanks so much! :o)
 
You can use an update query.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

Carla Stephenson said:
I have an entire spreadsheet that I have completed the "Copy" "Paste
Click to expand...
Special - values". I now need the values (not the display number) rounded
to the 2nd decimal place. Any tips? Thanks so much! :o)
 
As Rebecca notes, an Update query will solve this case.

FYI, for future cutting and pasting, be aware that Access'
Round function is different from Excel's; it only rounds
to the number of places AFTER the decimal point. If the
optional parameter is omitted, it rounds to the nearest
integer value.

To round the nearest ten, or 100, divide the number first,
round it, and multiple by the divisor again. For example,

Value Desired Value Formula
1011.74 1011.7 Round(value, 1)
1011.74 1012 Round(value)
1011.74 1010 10 * Round(value/10)
1011.74 1000 100 * Round(value/100)

HTH
Best regards.
Kevin Sprinkel
Becker & Frondorf
-----Original Message-----
I have an entire spreadsheet that I have completed
Click to expand...
the "Copy" "Paste Special - values". I now need the
values (not the display number) rounded to the 2nd decimal
place. Any tips? Thanks so much! :o)
 
Back
Top