P
Pekka Siiskonen
Hi,
First: Im in Finland, so the decimal separator here is comma -- not a dot!
So, I have an application that produces data containing product codes, names
and price information. The application uses decimal point, not comma.
In this application I'd like to paint, copy, and the in Excel 2000 "Paste
special" / "text" the data into Excel (data is conveniently tab separated so
it goes nicely into Excel cells), but:
One of the rows has price "12.5385" and if I "paste" or "paste special" /
"text" this to excel it converts into "Jou.85" (in english: "Dec.85")
Now then: Converting dot to comma has no effect after pasting the data to
Excel (other cells that Excel has not chosen to be dates convert nicely from
text to decimal values). Converting Format / cells / Number / Number
converts the original price of "12.5385" to "1272842". The magnitude of
error is drastic!
How can I guarantee that "Paste special" / "Text" does what it says:
"Inserts the contents of the Clipboard as text without any formatting" --
emphasis on word _text_ (i.e. not date!).
I know I can open the Notepad and paste the lot there, save as a text file
and open in Excel, and while importing a text file choose the related column
as "general" or "text". To me this is not a solution, nor chancing the
localisation parameters of Windows to accept dot as decimal separator for
all applications.
I use English Windows and Excel but the same happens with Finnish version of
Excel as well!
Pekka Siiskonen
First: Im in Finland, so the decimal separator here is comma -- not a dot!
So, I have an application that produces data containing product codes, names
and price information. The application uses decimal point, not comma.
In this application I'd like to paint, copy, and the in Excel 2000 "Paste
special" / "text" the data into Excel (data is conveniently tab separated so
it goes nicely into Excel cells), but:
One of the rows has price "12.5385" and if I "paste" or "paste special" /
"text" this to excel it converts into "Jou.85" (in english: "Dec.85")
Now then: Converting dot to comma has no effect after pasting the data to
Excel (other cells that Excel has not chosen to be dates convert nicely from
text to decimal values). Converting Format / cells / Number / Number
converts the original price of "12.5385" to "1272842". The magnitude of
error is drastic!
How can I guarantee that "Paste special" / "Text" does what it says:
"Inserts the contents of the Clipboard as text without any formatting" --
emphasis on word _text_ (i.e. not date!).
I know I can open the Notepad and paste the lot there, save as a text file
and open in Excel, and while importing a text file choose the related column
as "general" or "text". To me this is not a solution, nor chancing the
localisation parameters of Windows to accept dot as decimal separator for
all applications.
I use English Windows and Excel but the same happens with Finnish version of
Excel as well!
Pekka Siiskonen