Select the column in question, select Data from the taskbar, select text to Columns and press Finish on the Wizard.
I have a fields coming in that are text but should be numeric. is there a formula I can put in the cell to convert it from text to numeric?
The original database has the numeric fields stored as text, but I need to import them into Excel and do calculations on them.
Any assistance is GREATLY appreciated.
If you format the fields as Number before the import, it should convert.
Or you can use the VALUE function to convert them into a spare column, then use Copy, Paste Special, Values to overwrite the originals.
Last edited by ByTheCringe2; February 14th, 2007 at 02:49.
not possible to convert before hand. I am trying to create a template that will present the data and calculate values. The data is coming from a Lotus database that our programmers (external) do not have the time to convert the fields. So I need a function to convert the field to numeric so I can calculate values.
There are currently 1 users browsing this thread. (0 members and 1 guests)