G Guest Aug 23, 2006 #1 How can I enter over 15 digits in a cell without it rounding off the excess digits?
G Guest Aug 23, 2006 #2 You can't enter a numeric value > 15 digits so you need to format the cell as TEXT but obviously you cannot use this for calculations. Not for Credit Card Number by any chance? HTH
You can't enter a numeric value > 15 digits so you need to format the cell as TEXT but obviously you cannot use this for calculations. Not for Credit Card Number by any chance? HTH
M MyVeryOwnSelf Aug 23, 2006 #3 How can I enter over 15 digits in a cell without it rounding off the You can't enter a numeric value > 15 digits so you need to format the cell as TEXT but obviously you cannot use this for calculations. Click to expand... Start with an apostrophe ('). As noted above, this makes a text value, not numeric. You can’t do arithmetic with it the way you may expect.
How can I enter over 15 digits in a cell without it rounding off the You can't enter a numeric value > 15 digits so you need to format the cell as TEXT but obviously you cannot use this for calculations. Click to expand... Start with an apostrophe ('). As noted above, this makes a text value, not numeric. You can’t do arithmetic with it the way you may expect.
G Guest Aug 24, 2006 #4 No, transaction #'s and I don't need math calcs. So text is fine. I got it now thanks
