+ Reply to Thread
Results 1 to 2 of 2

Converting Numbers to Text properly

  1. #1
    Registered User
    Join Date
    09-17-2003
    Location
    Scotland
    Posts
    59

    Exclamation Converting Numbers to Text properly

    We have part numbers some of which are a mixture of text and numbers and some that are numbers only. Excel sees those parts consisting of only numbers as numbers rather than text. Even if I format the column to text, the numbers simply move to the left hand side but still see themselves as numbers. I know I can precede a numeric value with an apostrophe to make Excel see the cell contents as text however this is time consuming. Once I have formatted the column to text, I can then double click on each cell containing only numbers and it will then see itself as text but again this is time consuming. In other instances and particularly when bring the data into Excel from another source, Excel converts long part number to exponents which is no use at all as I can end up with duplicate parts – part no 234567112244 with show up as 2.34567E+11 and so does part no 234567112245 where the last digit is the only difference. Any suggestions.

  2. #2
    Peo Sjoblom
    Guest

    Re: Converting Numbers to Text properly

    If you format as text, it will be text. Left aligned is text
    don't know what you mean by
    "but still see themselves as numbers"

    If you bring it in as text you can use data>text to columns and select
    text as column data format in step 3


    --

    Regards,

    Peo Sjoblom


    "Shirley Munro" <[email protected]> wrote in
    message news:[email protected]...
    >
    > We have part numbers some of which are a mixture of text and numbers and
    > some that are numbers only. Excel sees those parts consisting of only
    > numbers as numbers rather than text. Even if I format the column to
    > text, the numbers simply move to the left hand side but still see
    > themselves as numbers. I know I can precede a numeric value with an
    > apostrophe to make Excel see the cell contents as text however this is
    > time consuming. Once I have formatted the column to text, I can then
    > double click on each cell containing only numbers and it will then see
    > itself as text but again this is time consuming. In other instances
    > and particularly when bring the data into Excel from another source,
    > Excel converts long part number to exponents which is no use at all as
    > I can end up with duplicate parts - part no 234567112244 with show up
    > as 2.34567E+11 and so does part no 234567112245 where the last digit is
    > the only difference. Any suggestions.
    >
    >
    > --
    > Shirley Munro
    > ------------------------------------------------------------------------
    > Shirley Munro's Profile:

    http://www.excelforum.com/member.php...nfo&userid=836
    > View this thread: http://www.excelforum.com/showthread...hreadid=345882
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1