+ Reply to Thread
Results 1 to 6 of 6

Cells won't convert to number format, even after format/cells/num.

  1. #1
    scottr
    Guest

    Cells won't convert to number format, even after format/cells/num.

    In excel, I tried to convert numbers to number format, using
    format/cells/number from the category list. But it won't take, and stays
    text-like. Any ideas?

  2. #2
    Dave Peterson
    Guest

    Re: Cells won't convert to number format, even after format/cells/num.

    If it turns out that you have spaces (or those non-breaking spaces), David
    McRitchie has some code that will help clean this junk up:

    http://www.mvps.org/dmcritchie/excel/join.htm#trimall
    (look for "Sub Trimall()")

    But after you format the cell as general, try selecting the cell, then hit F2,
    then enter.

    You have to make a change to the cell for the value to change from text to
    number.

    scottr wrote:
    >
    > In excel, I tried to convert numbers to number format, using
    > format/cells/number from the category list. But it won't take, and stays
    > text-like. Any ideas?


    --

    Dave Peterson

  3. #3
    PegL
    Guest

    RE: Cells won't convert to number format, even after format/cells/num.

    If the data was entered as text, it will stay text even if you reformat the
    cell. One way to correct this is to put a zero in a blank cell, copy it,
    then select the cells you want to be numeric, click Paste special and click
    on Add in the function section.

    "scottr" wrote:

    > In excel, I tried to convert numbers to number format, using
    > format/cells/number from the category list. But it won't take, and stays
    > text-like. Any ideas?


  4. #4
    Gord Dibben
    Guest

    Re: Cells won't convert to number format, even after format/cells/num.

    Peg

    Slight ammendment to your post, if I may.

    Copy a blank cell and paste special>add is easier then typing a zero in the
    cell then clearing it after the add.


    Gord Dibben Excel MVP

    On Tue, 12 Apr 2005 12:32:32 -0700, "PegL" <[email protected]>
    wrote:

    >If the data was entered as text, it will stay text even if you reformat the
    >cell. One way to correct this is to put a zero in a blank cell, copy it,
    >then select the cells you want to be numeric, click Paste special and click
    >on Add in the function section.
    >
    >"scottr" wrote:
    >
    >> In excel, I tried to convert numbers to number format, using
    >> format/cells/number from the category list. But it won't take, and stays
    >> text-like. Any ideas?



  5. #5
    Dave Peterson
    Guest

    Re: Cells won't convert to number format, even after format/cells/num.

    With the added benefit that blank cells won't turn to 0.



    Gord Dibben wrote:
    >
    > Peg
    >
    > Slight ammendment to your post, if I may.
    >
    > Copy a blank cell and paste special>add is easier then typing a zero in the
    > cell then clearing it after the add.
    >
    > Gord Dibben Excel MVP
    >
    > On Tue, 12 Apr 2005 12:32:32 -0700, "PegL" <[email protected]>
    > wrote:
    >
    > >If the data was entered as text, it will stay text even if you reformat the
    > >cell. One way to correct this is to put a zero in a blank cell, copy it,
    > >then select the cells you want to be numeric, click Paste special and click
    > >on Add in the function section.
    > >
    > >"scottr" wrote:
    > >
    > >> In excel, I tried to convert numbers to number format, using
    > >> format/cells/number from the category list. But it won't take, and stays
    > >> text-like. Any ideas?


    --

    Dave Peterson

  6. #6
    Gord Dibben
    Guest

    Re: Cells won't convert to number format, even after format/cells/num.

    Yeah, that too<g>

    Gord

    On Tue, 12 Apr 2005 16:31:05 -0500, Dave Peterson <[email protected]>
    wrote:

    >With the added benefit that blank cells won't turn to 0.
    >
    >
    >
    >Gord Dibben wrote:
    >>
    >> Peg
    >>
    >> Slight ammendment to your post, if I may.
    >>
    >> Copy a blank cell and paste special>add is easier then typing a zero in the
    >> cell then clearing it after the add.
    >>
    >> Gord Dibben Excel MVP
    >>
    >> On Tue, 12 Apr 2005 12:32:32 -0700, "PegL" <[email protected]>
    >> wrote:
    >>
    >> >If the data was entered as text, it will stay text even if you reformat the
    >> >cell. One way to correct this is to put a zero in a blank cell, copy it,
    >> >then select the cells you want to be numeric, click Paste special and click
    >> >on Add in the function section.
    >> >
    >> >"scottr" wrote:
    >> >
    >> >> In excel, I tried to convert numbers to number format, using
    >> >> format/cells/number from the category list. But it won't take, and stays
    >> >> text-like. Any ideas?



+ 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