Link to home
Start Free TrialLog in
Avatar of linwoodmwright
linwoodmwright

asked on

NEED EXCEL Function - Imported data needs to be converted from Text to Number

I'm importing data from a SQL Server 2008 Standard DB to Excel 2010.
The Column I'm importing is varchar and I need a function to convert it to a number in Excel so that I can run an IF function.

I've tried a lot of functions, but nothing does the trick.




Thanks,
Linwood
Avatar of Norie
Norie

There are various ways you could do it, without a formula.

Here's one.

Select a blank cell, select the data to be converted, goto Paste>Paste Speciall... and in the Operation section select Add(or Subtract).

Or you could convert it in SQL using CAST/CONVERT.
Avatar of linwoodmwright

ASKER

Thanks imnorie - This is a database connection, not a copy/paste import.  And, the data will be re-imported daily.

I cannot modify the SQL Server DB.
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
hmm - I've never seen that one.