Data Import & Export

Copy Excel Values to GraphPad with Two Decimal Places

Steve KSteve K Nov 14, 2026 868 views

Question details

The user wants to transfer Excel values to GraphPad using the same two-decimal values shown in the worksheet.

Copy Excel Values to GraphPad with Two Decimal Places
Product
Microsoft Excel and GraphPad Prism
Device & OS
not provided
Scenario
Copying numerical data from an Excel worksheet into a GraphPad data table.
Observed behavior
Excel can store more decimal places than it displays, so copied values may differ from the displayed two-decimal numbers.
Before you start

Check whether you need to round the underlying values or only display them with two decimal places. Identify an empty Excel column for the calculated values and a suitable destination table in GraphPad.

Solution 1Recommended

Round the Excel values before copying them to GraphPad

Use this method when GraphPad must receive values rounded to two decimal places rather than Excel's underlying higher-precision values.

1
Enter a rounding formula

In an empty column next to the source data, enter =ROUND(A2,2), replacing A2 with the first source cell.

2
Fill the formula down

Select the formula cell and drag its fill handle down alongside the remaining data.

3
Display two decimal places

Select the calculated cells, open Format Cells, choose Number, and set Decimal places to 2. This shows trailing zeros in Excel but does not change the formula results.

4
Copy into GraphPad

Copy the calculated cells, select the first destination cell in the GraphPad data table, and paste. If Paste Special is available, choose an option appropriate for inserting the copied data.

5
Check the result

Inspect a few pasted values in the GraphPad table and adjust its number display settings if trailing zeros are not shown.

Round the Excel values before copying them to GraphPad
Choose the rounding behavior: ROUND rounds to the nearest value. Use ROUNDUP to round away from zero, ROUNDDOWN to round toward zero, or TRUNC to remove digits beyond the specified decimal place.
Prepare data in WPS Spreadsheets

Round spreadsheet values in WPS before copying to GraphPad

Use WPS Spreadsheets to calculate two-decimal values, then copy the results into your GraphPad data table.

  1. 1. Open the workbook: In WPS Spreadsheets, use Open to select your Excel workbook.
  2. 2. Calculate rounded values: In an empty column, enter =ROUND(A2,2), replacing A2 with the first source cell, then drag the fill handle down.
  3. 3. Format the results: Select the results, open Format Cells, and set the Number format to two decimal places.
  4. 4. Transfer and check the data: Copy the calculated cells, paste them into the GraphPad data table, and check several values and their displayed decimal places.
Round values to two decimal places before transferring themOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and number formattingPrepare data in a free, easy-to-use office suite
QA img-9

Frequently Asked Questions

Why does Excel copy more decimal places than I can see?

Number formatting changes the displayed value, not necessarily the stored value. Use a formula such as =ROUND(A2,2) if the transferred value itself must be rounded.

How do I keep trailing zeros, such as 2.50, in GraphPad?

Format the destination values in GraphPad to display two decimal places. The numeric value 2.5 is the same as 2.50, so trailing zeros depend on display formatting.

What is the difference between ROUND and TRUNC?

ROUND(A2,2) rounds to the nearest value at two decimal places. TRUNC(A2,2) removes digits after the second decimal place without rounding.

Will Paste Special round my Excel values automatically?

Not necessarily. Paste Special controls how data is inserted, but you should round the source values with a formula and verify the pasted results when exact two-decimal values are required.