Only the text cells with zero convert to numeric

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi
probably you have some hidden characters in your data. Try:
=--SUBSTITUTE(A1,CHAR(160),"")
in an adjancent column
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
How can I migrate MBOX to PST? 2
Convert Text to numeric Value 8
Problem with concatination result. Last digit change to 0 1
Coverting text to numeric 5
Extract numerator from fraction 9
How can I keep a zero (0) at the front of a set of numbers. 2
Converting a numeric field to text 1

Back
Top