Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mise en forme | Excel Discussion (Misc queries) | |||
in cell allow to enter only text and number refrenced from other c | Excel Discussion (Misc queries) | |||
How do I enter a formula in a cell so that letters= a number i.e.. | New Users to Excel | |||
How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
You Must Enter A Number In This Cell | Excel Discussion (Misc queries) |