Converting numbers to text?

A

apoc330

Here is what I am doing:
I am opening some files in textpad(mainly because it will open and
concatenate multiple files) and then sorting the data without deleting
dupes. I then copy that data to excel and import as text. My problem is
that there are several cells that have .01 and .010 extensions that
excel still treats as the same even though they were imported as text
and it throws off my sumIF formula. Has anyone had this problem, and if
so please help?

Thanks
Sean
 
B

Bernard Liengme

You will need to explain more.
2.01 and 2.010 are mathematically the same (if they are measurements, one
is more precise than the other).
I can type 2.01 in to a cell, format the cell to show more decimals and it
will display as 2.010 or even 2.0100000000000.
 
A

apoc330

But what if you format or convert the cell to text, shouldn't exce
treat 2.010 and 2.0100 different? The problem I am having is that whe
I import the data that has file extensions such as these: .0, .00, .00
in column A and using the import wizard convert this column to text.
have to other columns that I leave as general data. I then copy colum
A back to textpad sort, and deduplicate the file extensions, bring i
back to excel in a new worksheet and convert the column to text onc
again. I then sumif(A:A.E:E,B:B) in an empty cell. Everything work
fine except when it gets to the file extensions .0, .000, or .00 th
sumif statement treats them as the same even though the column wa
converted to text. I got around this so far by placing an alph
character in front of the . i.e. A.00 and that fixes it. Does this mak
sense. Let me know if you need any more info
 
N

Niek Otten

<bring it back to excel in a new worksheet >

Here is probably where things go wrong.

You'll have to format the sheet as text *before* you paste the figures into
it.
 
Top