Copy/paste the value of a formula without commas!!
Solved
amaye
-
Mycacoy -
Mycacoy -
Hello,
I have data in an Excel 2010 table. At the end of the table, I have amounts (resulting from a formula).
I want to copy and paste this data into another Excel workbook without commas.
For example, if the formula gives me: 45 879; I want to have this exact number in the new workbook, but every time I do it, I get 45 879, 1245......
Please note: this is not a problem with decimals; even when I disable the decimal option, when I enter the cell, I can see in the formula bar that the numbers after the comma are still there.
Thank you for your support.
Configuration: Windows 7 / Internet Explorer 8.0
I have data in an Excel 2010 table. At the end of the table, I have amounts (resulting from a formula).
I want to copy and paste this data into another Excel workbook without commas.
For example, if the formula gives me: 45 879; I want to have this exact number in the new workbook, but every time I do it, I get 45 879, 1245......
Please note: this is not a problem with decimals; even when I disable the decimal option, when I enter the cell, I can see in the formula bar that the numbers after the comma are still there.
Thank you for your support.
Configuration: Windows 7 / Internet Explorer 8.0
3 réponses
You need to modify your formula before doing your copy-paste:
instead of =myformula
write =ROUND(myformula;0)
Retirement is good! Especially in the West Indies... :-)
☻ Raymond ♂
instead of =myformula
write =ROUND(myformula;0)
Retirement is good! Especially in the West Indies... :-)
☻ Raymond ♂
Mycacoy
Great! It's working! A thousand thanks.
