number length limit

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jhahes - 22 Mar 2006 00:08 GMT

I am putting a number in cell A1

the number is an order number that was generated
however when I put in the number, the last few digits are showing a
0's.

Is there any way to fix this, here is my number.

200603191216515085

and it is showing as

200603191216515000

Thanks for any hel

Reply to this Message

Trevor Shuttleworth - 22 Mar 2006 00:15 GMT

Put an apostrophe (single quote) in front of the number

'200603191216515085

or format the cell as text

Regards

Trevor

> I am putting a number in cell A1
>
[quoted text clipped - 11 lines]
>
> Thanks for any help

Reply to this Message

Dick Kusleika - 22 Mar 2006 00:19 GMT

jhahes

Excel supports 15 significant digits. Since you won't be doing any math on
this, it's not really a number, but text. Precede the number with an
apostrophe and you can enter as many numerals as you like.

Signature

Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com

> I am putting a number in cell A1
>
[quoted text clipped - 11 lines]
>
> Thanks for any help

Reply to this Message