ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   i want to enter more then 16 number in one cell without text forme (https://www.excelbanter.com/excel-discussion-misc-queries/143783-i-want-enter-more-then-16-number-one-cell-without-text-forme.html)

Ganesh Pawar

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

Bernard Liengme

i want to enter more then 16 number in one cell without text forme
 
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Ganesh Pawar" <Ganesh wrote in message
...
i want to enter more then 16 number in one cell without text formet




Barb Reinhardt

i want to enter more then 16 number in one cell without text forme
 
IIRC, No Can Do.

"Ganesh Pawar" wrote:

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


David Biddulph[_2_]

i want to enter more then 16 number in one cell without text forme
 
You can do it if all the digits after the 15th one are zeroes.
Otherwise, you're out of luck.
--
David Biddulph

"Ganesh Pawar" <Ganesh wrote in message
...
i want to enter more then 16 number in one cell without text formet





All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com