Copy / paste

Alexander · Apr 29th, 2002, 11:22 AM

How do I copy and paste the rounded number, not the decimal pointed number? Example: I have an amount in cell A1 of 110.75 and I want to paste 111, or the rounded up equivalent. I want the cell to read 111, not just be formatted without the decimals, so that if it is parsed it will be parsed as 111.

Anne Troy · Apr 29th, 2002, 12:29 PM

I don't think it's possible to PASTE the rounded number. Where do you want to paste it? Into another cell/worksheet/workbook? Same cell?

Alexander · Apr 29th, 2002, 12:30 PM

I want to paste it into another cell.

Anne Troy · Apr 29th, 2002, 12:39 PM

Don't paste.

Just use =ROUND(A1,0)

Where A1 is the cell that currently contains 110.75

Alexander · Apr 29th, 2002, 12:58 PM

Thanks! That works!

Apr 29th, 2002, 12:29 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	I don't think it's possible to PASTE the rounded number. Where do you want to paste it? Into another cell/worksheet/workbook? Same cell? __________________ ~Anne Troy

Apr 29th, 2002, 12:39 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Don't paste. Just use =ROUND(A1,0) Where A1 is the cell that currently contains 110.75 __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 11:22 AM	#1
Alexander New Member Join Date: Apr 2002 Posts: 45	How do I copy and paste the rounded number, not the decimal pointed number? Example: I have an amount in cell A1 of 110.75 and I want to paste 111, or the rounded up equivalent. I want the cell to read 111, not just be formatted without the decimals, so that if it is parsed it will be parsed as 111.

Apr 29th, 2002, 12:30 PM	#3
Alexander New Member Join Date: Apr 2002 Posts: 45	I want to paste it into another cell.

Apr 29th, 2002, 12:58 PM	#5
Alexander New Member Join Date: Apr 2002 Posts: 45	Thanks! That works!