| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert text to number
Hi all,
when I copy and paste data to my worksheet, the numbers appear to be formatted as text. I can easily convert these to numbers by either selecting the error message and converting or using the special paste method and so on. However, my spreadsheet requires for data to be copied and pasted continuously and I dont want to have to convert the text to numbers every time. Is there a way this could be automated with some code? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text number to number formate | Excel Discussion (Misc queries) | |||
| Convert a number formatted as text to a number in a macro | Excel Programming | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
| Convert number in text format to number | Excel Programming | |||
Threaded Mode
