![]() |
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
|
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 |
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 |
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