Home 
Search 
Today's Posts 
#1




Copy & Paste value Function
When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal
points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I can paste the value by two decimal points only. Again for example xx.xx instead of xx.xxxxxx. Thanks in advance for the solution. DS 
#2




Copy & Paste value Function
Just preformat the cell(s)
 Don Guillett SalesAid Software "Dinesh" wrote in message ... When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I can paste the value by two decimal points only. Again for example xx.xx instead of xx.xxxxxx. Thanks in advance for the solution. DS 
#3




Copy & Paste value Function
Paste Values does exactly what it says on the tin and only pastes values.
This means that your data will take on whatever format the cell has, so if it hasn't been formatted as anything before it will default to general and you will get a load of decimals as you are seeing. I'm guessing that what you really want to do is simply do it twice, paste as normal which will likely give you garbage data but the correct formats, and then do paste special as values and you get the best of both worlds.  Regards Ken....................... Microsoft MVP  Excel Sys Spec  Win XP Pro / XL 97/00/02/03 ** It's easier to beg forgiveness than ask permission :) ** "Dinesh" wrote in message ... When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I can paste the value by two decimal points only. Again for example xx.xx instead of xx.xxxxxx. Thanks in advance for the solution. DS 
#4




Copy & Paste value Function
Hi don, After formatting, visibly there are only two decimals, but when you
click on the cell, it has more than two decimals. How do I truncate the more than two deicmal points? "Don Guillett" wrote: Just preformat the cell(s)  Don Guillett SalesAid Software "Dinesh" wrote in message ... When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I can paste the value by two decimal points only. Again for example xx.xx instead of xx.xxxxxx. Thanks in advance for the solution. DS 
#5




Copy & Paste value Function
You can use precision as displayed under toolsoptionscalculation
 Regards, Peo Sjoblom Excel 95  Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Dinesh" wrote in message ... Hi don, After formatting, visibly there are only two decimals, but when you click on the cell, it has more than two decimals. How do I truncate the more than two deicmal points? "Don Guillett" wrote: Just preformat the cell(s)  Don Guillett SalesAid Software "Dinesh" wrote in message ... When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I can paste the value by two decimal points only. Again for example xx.xx instead of xx.xxxxxx. Thanks in advance for the solution. DS 
#6




Copy & Paste value Function
Thanks, Peo works very well.
"Peo Sjoblom" wrote: You can use precision as displayed under toolsoptionscalculation  Regards, Peo Sjoblom Excel 95  Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "Dinesh" wrote in message ... Hi don, After formatting, visibly there are only two decimals, but when you click on the cell, it has more than two decimals. How do I truncate the more than two deicmal points? "Don Guillett" wrote: Just preformat the cell(s)  Don Guillett SalesAid Software "Dinesh" wrote in message ... When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I can paste the value by two decimal points only. Again for example xx.xx instead of xx.xxxxxx. Thanks in advance for the solution. DS 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Copy and paste Excel chart in Word  font compresses  Charts and Charting in Excel  
How to copy & paste excel charts to Words as Windows Metafile  Charts and Charting in Excel  
Copy / Paste Function & the Office Clipboard  Excel Discussion (Misc queries)  
Copy & Paste  Excel Discussion (Misc queries)  
copy paste cell character limit  Excel Discussion (Misc queries) 