Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Convert A Text Field To Numeric On Import

  1. #1
    Join Date
    2nd February 2007
    Posts
    8

    Convert A Text Field To Numeric On Import

    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.

    Thanks
    jim

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Location
    Berkshire UK
    Posts
    426

    Re: Convert A Text Field To Numeric On Import

    Hi

    Select the column in question, select Data from the taskbar, select text to Columns and press Finish on the Wizard.

    HTH

    Robert

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Convert A Text Field To Numeric On Import

    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 01:49.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    2nd February 2007
    Posts
    8

    Re: Convert A Text Field To Numeric On Import

    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.
    Thanks
    Jim

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    2nd February 2007
    Posts
    8

    Re: Convert A Text Field To Numeric On Import

    Robert thanks for your help but what I am trying to do is have it automatically convert upon opening the excel worksheet.

    Thanks

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    7th December 2005
    Location
    Hampshire, England
    Posts
    4,898

    Re: Convert A Text Field To Numeric On Import

    If you can have an extra column to put the converted value in, use the formula

    =VALUE(A1)

    Otherwise you will need to use VBA. All other methods need you to do something after the import.

    Excel Video Tutorials / Excel Dashboards Reports


  7. #7
    Join Date
    2nd February 2007
    Posts
    8

    Re: Convert A Text Field To Numeric On Import

    Thanks I will try that right now and get back to you.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Convert Text Field To Date In Sql
    By mjschukas in forum Excel and/or Access Help
    Replies: 19
    Last Post: October 9th, 2006, 12:35
  2. Convert text od Date into Date field
    By tqv1969 in forum EXCEL HELP
    Replies: 8
    Last Post: March 16th, 2006, 23:21
  3. Replies: 9
    Last Post: July 21st, 2004, 03:19
  4. Replies: 2
    Last Post: July 10th, 2004, 17:13
  5. convert text to numeric
    By beeker in forum EXCEL HELP
    Replies: 13
    Last Post: April 20th, 2004, 06:02

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno