When you import the text file, numbers should become numbers. If they are not, please, set the column where the $ values should be to be either General or numbers. Then the $ format should work and you can increase the number of digits after the decimal point for the entire column. That might be easiest under the 'number' property where you'd specify 2, but I'm not sure that's really needed.
Excel2003 has a somewhat helpful thing - it can show possible errors if enabled in Options. Such that a little triangle shows on the cell, which might say something to the effect 'this looks like text, should we treat it as a number'. See if that helps.
I think the only way Excel would see 101.2 as text is if there was a character, even space, before the number and you're not parsing on spaces and suppressing repeated spaces. I'm not sure what $ would do in front of a number. Perhaps that's the problem, in which case in Notepad just replace $ by nothing.
What other things are you importing? It might help if you showed an example of a row or two of data. Now, the forum format will probably destroy tabs or multiple spaces, so try to describe it as well as you can.
I just gave Excel a file containing
where I have one space just before the number. I told the importer to split on space, and indeed, the second column became General, with both values being 101.2 and 101.3. In C1 I added 1 to B1, and the result was a number. Then I asked to format column B to Currency, it automatically made the values into 101.20 and 102.30 with $ in front. So, I can't replicate your problem.
Probably, because I misunderstood your description someplace
Edited by tos226, 14 April 2007 - 09:00 PM.