i want to enter more then 16 number in one cell without text forme

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ganesh Pawar - 23 May 2007 13:28 GMT

i want to enter more then 16 number in one cell without text formet

Reply to this Message

Bernard Liengme - 23 May 2007 13:31 GMT

Begin by typing a single quote (apostrophe ') then the 16 digits.
Beware this will behave as text.
If you want bigger numbers Google for XNUMBERS add-in
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>i want to enter more then 16 number in one cell without text formet

Reply to this Message

Barb Reinhardt - 23 May 2007 13:32 GMT

IIRC, No Can Do.

> i want to enter more then 16 number in one cell without text formet

Reply to this Message

David Biddulph - 23 May 2007 14:11 GMT

You can do it if all the digits after the 15th one are zeroes.
Otherwise, you're out of luck.

Signature

David Biddulph

>i want to enter more then 16 number in one cell without text formet

Reply to this Message