software

Hi all,

Quick question.

When I type in 123456789123456789 in the cell, Excel convert it into
123456789123456000 no matter cell is in number or text.
How can I display it correctly.

Thank you--
TJS
------------------------------------------------------------------------
TJS's Profile: www.excelforum.com/member.php...oamp;userid=29583
View this thread: www.excelforum.com/showthread...hreadid=494277XL's specifications (See XL Help: quot;Specificationsquot;) allow only 15
decimal digits of precision.

You can preformat the cell as Text or prefix the entry with an
apostrophe ('), but it will no longer be a number that you can do math
with.In article gt;,
TJS gt; wrote:

gt; Hi all,
gt;
gt; Quick question.
gt;
gt; When I type in 123456789123456789 in the cell, Excel convert it into
gt; 123456789123456000 no matter cell is in number or text.
gt; How can I display it correctly.
gt;
gt; Thank you


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: www.excelforum.com/member.php...oamp;userid=29583
View this thread: www.excelforum.com/showthread...hreadid=494277Did you already have the digits entered in the one cell when you formatted
to text?

Rob

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

It was same either way, before or after.

Odd--
TJS
------------------------------------------------------------------------
TJS's Profile: www.excelforum.com/member.php...oamp;userid=29583
View this thread: www.excelforum.com/showthread...hreadid=494277Hmmm, 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.

Robquot;TJSquot; gt; wrote in message
...
gt;
gt; It was same either way, before or after.
gt;
gt; Odd
gt;
gt;
gt; --
gt; TJS
gt; ------------------------------------------------------------------------
gt; TJS's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29583
gt; View this thread: www.excelforum.com/showthread...hreadid=494277
gt;

Thanks Rob,

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

TJ--
TJS
------------------------------------------------------------------------
TJS's Profile: www.excelforum.com/member.php...oamp;userid=29583
View this thread: www.excelforum.com/showthread...hreadid=494277I 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:

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

--

Dave Peterson