i want to enter more then 16 number in one cell without text formet
B Bernard Liengme May 23, 2007 #2 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
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
D David Biddulph May 23, 2007 #4 You can do it if all the digits after the 15th one are zeroes. Otherwise, you're out of luck.