Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel is automatically doing "text to columns" upon paste text. | Excel Discussion (Misc queries) | |||
Paste along side any text etc | Excel Discussion (Misc queries) | |||
How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel | |||
returning a text cell based on a number cell | Excel Worksheet Functions |