Someting strange

Computer related discussions

Moderator: Rebel Security

Post Reply
User avatar
Memphis Jack
Bench Warmer
Bench Warmer
Posts: 366
Joined: Mon Aug 29, 2005 10:19 am
Location: Germantown, TN

Someting strange

Post by Memphis Jack » Mon Jul 27, 2009 7:52 pm

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!

User avatar
rewalters
Rebel Legend
Rebel Legend
Posts: 3006
Joined: Mon Mar 27, 2006 11:26 am
Location: Soso, Ms

Post by rewalters » Mon Jul 27, 2009 9:32 pm

Try setting it as text, that should allow you to put the numbers as typed.
Randy

User avatar
Memphis Jack
Bench Warmer
Bench Warmer
Posts: 366
Joined: Mon Aug 29, 2005 10:19 am
Location: Germantown, TN

Post by Memphis Jack » Tue Jul 28, 2009 2:49 pm

Randy
That worked. I should have thought of it. Thanks.
Jack

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest