Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
desperate.. convert to number column...
I've tried this for couple hours and it's time to seek help now.
I have a big chunk of data importing from Klippel, a software that I believe most people rarely used it. when I use isnumber on the cells, the result is false. I have followed over 5 methods (I want automatic method so that I don't need to type in manually) but all failed. I follow the thread he http://support.microsoft.com/kb/181298 tried out almost all the method but have no good luck. Anyone can direct me how to do that? I want to attach my file here but how can I do that? Thanks... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
desperate.. convert to number column...
Not sure which methods you've used...
Have you tried typing the number 1 into a blank cell, copying this cell, highlighting your expected ukbers, paste special/multiply? this would force format change to number... "triple" wrote: I've tried this for couple hours and it's time to seek help now. I have a big chunk of data importing from Klippel, a software that I believe most people rarely used it. when I use isnumber on the cells, the result is false. I have followed over 5 methods (I want automatic method so that I don't need to type in manually) but all failed. I follow the thread he http://support.microsoft.com/kb/181298 tried out almost all the method but have no good luck. Anyone can direct me how to do that? I want to attach my file here but how can I do that? Thanks... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Header - Convert a Number to a letter | Excel Discussion (Misc queries) | |||
convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
how do I convert a number to number of years, months and days | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) |