Closed Thread
Results 1 to 5 of 5

format of cell

  1. #1
    Scudo
    Guest

    format of cell

    I am trying to type in 2-26 in a cell, I have the cell as `general` format
    but it keeps jumping back to custom and giving 46413.
    Is there something else I should be doing?

    thanks



  2. #2
    Guest

    Re: format of cell

    Hi
    Try entering it with a ' first ie '2-26
    Excel is trying to help you by interpreting what you enter as something else
    (probably a date).
    Alternatively, format the cell as text before you enter the data.

    --
    Andy.


    "Scudo" <me@nospam.fictional> wrote in message
    news:qxNbe.40920$TZ6.2900@fe3.news.blueyonder.co.uk...
    >I am trying to type in 2-26 in a cell, I have the cell as `general` format
    > but it keeps jumping back to custom and giving 46413.
    > Is there something else I should be doing?
    >
    > thanks
    >
    >




  3. #3
    alnav89
    Guest

    RE: format of cell

    I went to format the cell and chose text.. then typed the info and it came
    out 2-26 as a label

    "Scudo" wrote:

    > I am trying to type in 2-26 in a cell, I have the cell as `general` format
    > but it keeps jumping back to custom and giving 46413.
    > Is there something else I should be doing?
    >
    > thanks
    >
    >
    >


  4. #4
    Scudo
    Guest

    Re: format of cell

    Thanks Andy that worked.


    "Scudo" <me@nospam.fictional> wrote in message
    news:qxNbe.40920$TZ6.2900@fe3.news.blueyonder.co.uk...
    > I am trying to type in 2-26 in a cell, I have the cell as `general` format
    > but it keeps jumping back to custom and giving 46413.
    > Is there something else I should be doing?
    >
    > thanks
    >
    >




  5. #5
    Guest

    Re: format of cell

    Thanks for the feedback. Glad to help!

    --
    Andy.


    "Scudo" <me@nospam.fictional> wrote in message
    news:JXNbe.1156$nX3.1036@fe1.news.blueyonder.co.uk...
    > Thanks Andy that worked.
    >
    >
    > "Scudo" <me@nospam.fictional> wrote in message
    > news:qxNbe.40920$TZ6.2900@fe3.news.blueyonder.co.uk...
    >> I am trying to type in 2-26 in a cell, I have the cell as `general`
    >> format
    >> but it keeps jumping back to custom and giving 46413.
    >> Is there something else I should be doing?
    >>
    >> thanks
    >>
    >>

    >
    >




Closed 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