title: Pasting decimal numbers in excel / comma and point decimal separator
body: <p>I want to get data into excel using DDE. I get an new value every second from the DDE and use a macro to store every value in the next row. So for so good.</p>
  
  <p>Problem is the decimal separator. </p>
  
  <p>I get from the DDE a value like -5.18834
  Using the macro or pasting it into excel, the value shows -518.557 but the actual value is -518557.
  The decimal point gets wrongly interpreted by excel. When I paste the same value in notepad I get correct value i.e. -5.18557
  I tried deviding the value by 10000 in excel, but some values are 5 numbers instead of 6, so then it's wrong again.</p>
  
  <p>I tried formatting cells, changing decimal separator in excel's options, changed regional setting on my pc but none of those work.
  I also tried adding TextFileDecimalSeparator = "." in the macro (found on this website) but that doesn't work either.
  Processing the data after the macro has finished is not an option.</p>
  
  <p>Thanks for any help.</p>