Entering Large Number

OK That'sf what I did, with a little twist though...

When I format just 1 cell to text, it did the same 15 digits thing.
When I format the whole column to text, it finally displayed right.
What gives?

Thanks,

Did you already have the digits entered in the one cell when you formatted
to text?

Rob

"TJS" <TJS.205v0n_1134783601.4588@excelforum-nospam.com> wrote in message
news:TJS.205v0n_1134783601.4588@excelforum-nospam.com...
>
> OK That'sf what I did, with a little twist though...
>
> When I format just 1 cell to text, it did the same 15 digits thing.
> When I format the whole column to text, it finally displayed right.
> What gives?
>
> Thanks,
>
>
> --
> TJS
> ------------------------------------------------------------------------
> TJS's Profile:
> http://www.excelforum.com/member.php...o&userid=29583
> View this thread: http://www.excelforum.com/showthread...hreadid=494277
>

It was same either way, before or after.

Odd

Hmmm, a bit odd I agree.

I have had occassions in the past when trying to change the format of a cell
doesn't seem to take affect as it should. I then drag a correctly formatted
cell to the problem cell which seemed to override the format which fixed the
problem. Don't know if that would fix your situation, but I don't have any
other ideas.

Rob


"TJS" <TJS.205vxy_1134784800.5887@excelforum-nospam.com> wrote in message
news:TJS.205vxy_1134784800.5887@excelforum-nospam.com...
>
> It was same either way, before or after.
>
> Odd
>
>
> --
> TJS
> ------------------------------------------------------------------------
> TJS's Profile:
> http://www.excelforum.com/member.php...o&userid=29583
> View this thread: http://www.excelforum.com/showthread...hreadid=494277
>

Thanks Rob,

I openned another work sheet and does the same. So got to be be my application issue.

TJ

I cannot reproduce the behaviour that I understand you to be describing
here. What version of Excel? What steps exactly?

Prefixing with an apostrophe is always reliable.

Jerry

TJS wrote:

> OK That'sf what I did, with a little twist though...
>
> When I format just 1 cell to text, it did the same 15 digits thing.
> When I format the whole column to text, it finally displayed right.
> What gives?
>
> Thanks,

If you formatted the cell after you did the data entry, it's too late.

If you formatted that cell before you did the data entry, then try formatting it
once more--I'm betting that you made a minor mistake (maybe hit cancel instead
of ok???).

TJS wrote:
>
> OK That'sf what I did, with a little twist though...
>
> When I format just 1 cell to text, it did the same 15 digits thing.
> When I format the whole column to text, it finally displayed right.
> What gives?
>
> Thanks,
>
> --
> TJS
> ------------------------------------------------------------------------
> TJS's Profile: http://www.excelforum.com/member.php...o&userid=29583
> View this thread: http://www.excelforum.com/showthread...hreadid=494277

--

Dave Peterson