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!

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

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

I'm not sure if this is a full excel integration, but maybe you could export
your data into a text file.

Then you could open that file in excel. And when you do the file|open, you'll
see the text to columns wizard popup. You can specify the type of field for
each column--including text for this one.

Since that exported file will always have the same format, you could record a
macro when you open the text file -- continue recording when you add
headers/subtotals/filters/print layout and it might even make it easier for the
user.

(Too much excel????)

Alex Häflliger wrote:

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


--

Dave Peterson