Copy Excel Values to GraphPad with Two Decimal Places
Question details
The user wants to transfer Excel values to GraphPad using the same two-decimal values shown in the worksheet.

- 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.
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.
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.
In an empty column next to the source data, enter =ROUND(A2,2), replacing A2 with the first source cell.
Select the formula cell and drag its fill handle down alongside the remaining data.
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.
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.
Inspect a few pasted values in the GraphPad table and adjust its number display settings if trailing zeros are not shown.

Use GraphPad Paste Special to control data insertion
Use this option when you want to choose how copied Excel data is inserted into a GraphPad table.
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. Open the workbook: In WPS Spreadsheets, use Open to select your Excel workbook.
- 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. Format the results: Select the results, open Format Cells, and set the Number format to two decimal places.
- 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.

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.




