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?
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?
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
__________________________
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
> __________________________
>
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
>> __________________________
>>
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
> >> __________________________
> >>
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks