View Single Post
  #1   Report Post  
Alex Häflliger
 
Posts: n/a
Default Paste a number as text

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!