View original (French)

Copy/paste the value of a formula without commas!!

Solved
amaye -  
 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

3 answers

  1.
    Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 489
     
    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 ♂
    3
    1. Mycacoy
       
      Great! It's working! A thousand thanks.
      0
  2. karirovax Posted messages 3584 Status Member 215
     
    Hi

    Does this help you:

    ActiveCell.Value = Replace(ActiveCell.Value, ";", "")
    0
  3. mohamedag Posted messages 6 Status Member 7
     
    Thank you, Raymond.
    0