Page 1 of 1

Someting strange

Posted: Mon Jul 27, 2009 7:52 pm
by Memphis Jack
I have encountered a strange situation. Entering rather long numbers into Excel (eg. credit card numbers) I've have a situation where the last few digits are accepted as Zeros no matter what I type. For example, 123456789 becomes 123450000 I have tried reformatting the cells to accept the number, but nothing has worked. I have never had this problem. Any ideas!

Posted: Mon Jul 27, 2009 9:32 pm
by rewalters
Try setting it as text, that should allow you to put the numbers as typed.

Posted: Tue Jul 28, 2009 2:49 pm
by Memphis Jack
Randy
That worked. I should have thought of it. Thanks.
Jack