+ Reply to Thread
Results 1 to 2 of 2

Exporting Problems

  1. 10-20-2014, 08:04 AM #1
    MojoSA
    MojoSA is offline
    Registered User
    Join Date
    10-20-2014
    Location
    Johannesburg
    MS-Off Ver
    2007
    Posts
    1

    Exporting Problems

    Good Day Folks

    I am having trouble when exporting a list of mobile numbers onto excel.
    The excel document displays all the mobile numbers but drops a "0" before all the numbers.

    Any guidance would be most welcome

    Thanks

    Mo
    Reply With QuoteRegister To Reply
  2. 10-20-2014, 08:15 AM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Exporting Problems

    Hi, and welcome to the forum.

    The field you're importing them to needs to be formatted as a Text field. Currently it will be numeric and leading zeros in a number are not significant.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro for Exporting Outlook Messages to Excel - Split Subject problems
    By jbeans in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-04-2013, 08:29 PM
  2. [SOLVED] Problems with sorting andf Pivot Table problems
    By Saturn in forum Excel General
    Replies: 4
    Last Post: 10-07-2012, 07:47 AM
  3. Excel 2007 : Date problems and deletion problems - need a bit of professional help!
    By terri232 in forum Excel General
    Replies: 0
    Last Post: 12-25-2011, 04:30 PM
  4. [SOLVED] Problems with quotation mark when exporting to a .txt file
    By latet in forum Excel General
    Replies: 2
    Last Post: 03-20-2006, 06:30 AM
  5. Exporting xml problems
    By geviez in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2005, 02:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1