How do I enter numbers in a cell without the last number always defaulting to zero?
P parlayman Sep 4, 2004 #1 How do I enter numbers in a cell without the last number always defaulting to zero?
M Myrna Larson Sep 4, 2004 #2 Are you trying to enter numbers with 16 or more digits? XL's limit is 15 digits.
F Frank Kabel Sep 4, 2004 #3 Hi if you have more than 15 digits (e.g. credit card numbers) try: - precede your entries with an apostrophe: '1234567890123456 - or format the cell as 'Text'
Hi if you have more than 15 digits (e.g. credit card numbers) try: - precede your entries with an apostrophe: '1234567890123456 - or format the cell as 'Text'
