View Single Post
  #3   Report Post  
Alex Häflliger
 
Posts: n/a
Default

We have to export a full list. This is done automatically through our
software. Untill now we copy the list into the clipboard and paste it in
excel, but this causes the described problem.
We are looking for a solution where we don't have to implement a full excel
integration.

"Dave Peterson" wrote:

If it's just one cell, format it as text and paste directly into the formula
bar.

Alex Häflliger wrote:

We often use the copy paste function to export some data from our software
into excel for further analysis. In one colomn we have a text field which
containes sometimes only numers like "23000.3000". If we copy and paste this
field, the result in excel would be "23000.3". (It is interpreted as number)
We tried already to add a ' before the value but the the ' is showed as
normal letter.
Is there any solution to paste any number as a text in Excel without
programming a full Excel automation.
Thank you for your help!


--

Dave Peterson