Only the text cells with zero convert to numeric

S

S4URBE (Ron)

Office 2003 Field is defined as a type 2 (text) field. Using the method
described in "Convert numbers stored as text to numbers" only the zero value
fields convert to a type 1 (numeric). The source for the file was HTML which
I copied and paste special as HTML. I saved as .TXT thinking the numerics
would convert but did'nt. Suggestions?
 
F

Frank Kabel

Hi
probably you have some hidden characters in your data. Try:
=--SUBSTITUTE(A1,CHAR(160),"")
in an adjancent column
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Using formula to convert date result to text 3
Visio: copy text of a master shape to User-define Cells (Variable) 0
Convert Text to numeric Value 8
Problem with concatination result. Last digit change to 0 1
Number stored as text 4
Convert Text to Numeric 2
Move Chart with Text 0

Top