+ Reply to Thread
Results 1 to 5 of 5

Excel puts a 0 at the end of my number

  1. #1
    Dan Connors
    Guest

    Excel puts a 0 at the end of my number

    I am putting large number into a cell, why does Excel changing my last number
    to a zero? Is there a way to leave it the way I want it?

  2. #2
    Richard Buttrey
    Guest

    Re: Excel puts a 0 at the end of my number

    On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors"
    <DanConnors@discussions.microsoft.com> wrote:

    >I am putting large number into a cell, why does Excel changing my last number
    >to a zero? Is there a way to leave it the way I want it?



    By a large number, I guess you mean one containing > 15 digits.

    You need to format the cell as text. You won't of course be able to do
    any arithmetic with it.

    HTH

    __
    Richard Buttrey
    Grappenhall, Cheshire, UK
    __________________________

  3. #3
    Dan Connors
    Guest

    Re: Excel puts a 0 at the end of my number

    Thank you for the quick response.

    I did try this and it is still rounding my number. I don't need to calculate
    it, but I do need that last number to display. I put the number in quotes,
    and than ran a right and left function. This got the number...is there
    another way?

    "Richard Buttrey" wrote:

    > On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors"
    > <DanConnors@discussions.microsoft.com> wrote:
    >
    > >I am putting large number into a cell, why does Excel changing my last number
    > >to a zero? Is there a way to leave it the way I want it?

    >
    >
    > By a large number, I guess you mean one containing > 15 digits.
    >
    > You need to format the cell as text. You won't of course be able to do
    > any arithmetic with it.
    >
    > HTH
    >
    > __
    > Richard Buttrey
    > Grappenhall, Cheshire, UK
    > __________________________
    >


  4. #4
    Chip Pearson
    Guest

    Re: Excel puts a 0 at the end of my number

    Precede the number with an apostrophe ('). The apostrophe will
    not show in the cell, but will display in the formula bar.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com

    "Dan Connors" <DanConnors@discussions.microsoft.com> wrote in
    message
    news:1373044D-000D-495F-8851-047FC779295D@microsoft.com...
    > Thank you for the quick response.
    >
    > I did try this and it is still rounding my number. I don't need
    > to calculate
    > it, but I do need that last number to display. I put the number
    > in quotes,
    > and than ran a right and left function. This got the
    > number...is there
    > another way?
    >
    > "Richard Buttrey" wrote:
    >
    >> On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors"
    >> <DanConnors@discussions.microsoft.com> wrote:
    >>
    >> >I am putting large number into a cell, why does Excel
    >> >changing my last number
    >> >to a zero? Is there a way to leave it the way I want it?

    >>
    >>
    >> By a large number, I guess you mean one containing > 15
    >> digits.
    >>
    >> You need to format the cell as text. You won't of course be
    >> able to do
    >> any arithmetic with it.
    >>
    >> HTH
    >>
    >> __
    >> Richard Buttrey
    >> Grappenhall, Cheshire, UK
    >> __________________________
    >>




  5. #5
    Dan Connors
    Guest

    Re: Excel puts a 0 at the end of my number

    Great!!!

    Thanks

    "Chip Pearson" wrote:

    > Precede the number with an apostrophe ('). The apostrophe will
    > not show in the cell, but will display in the formula bar.
    >
    >
    > --
    > Cordially,
    > Chip Pearson
    > Microsoft MVP - Excel
    > Pearson Software Consulting, LLC
    > www.cpearson.com
    >
    > "Dan Connors" <DanConnors@discussions.microsoft.com> wrote in
    > message
    > news:1373044D-000D-495F-8851-047FC779295D@microsoft.com...
    > > Thank you for the quick response.
    > >
    > > I did try this and it is still rounding my number. I don't need
    > > to calculate
    > > it, but I do need that last number to display. I put the number
    > > in quotes,
    > > and than ran a right and left function. This got the
    > > number...is there
    > > another way?
    > >
    > > "Richard Buttrey" wrote:
    > >
    > >> On Fri, 4 Nov 2005 10:49:10 -0800, "Dan Connors"
    > >> <DanConnors@discussions.microsoft.com> wrote:
    > >>
    > >> >I am putting large number into a cell, why does Excel
    > >> >changing my last number
    > >> >to a zero? Is there a way to leave it the way I want it?
    > >>
    > >>
    > >> By a large number, I guess you mean one containing > 15
    > >> digits.
    > >>
    > >> You need to format the cell as text. You won't of course be
    > >> able to do
    > >> any arithmetic with it.
    > >>
    > >> HTH
    > >>
    > >> __
    > >> Richard Buttrey
    > >> Grappenhall, Cheshire, UK
    > >> __________________________
    > >>

    >
    >
    >


+ 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