LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default "Bug" in number format for long number entries?

Hi,

I was keeping track of my credit card numbers with a spreadsheet. And when
I enter a cc numer such as a visa card the last digit gets rounded to a "0"
No matter what I tried this happened. But it doesn't happen in Excel 2003!

I checked to be sure I was using a correct format (number entry in the cell
and column I was in). I even tried chnaging the format to currency, etc, but
nothing would work. The last digit no matter what I enter gets changed to a
zero.

This seems to happen beginning with the 16th number and actually continues
if you enter more than 15 numbers (i.e. 16 numbers, 17 numbers, etc.)

Try it ! Any ideas.
Tx Chippo
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need formula for dividing by "number of entries" in a column or row [email protected] Excel Discussion (Misc queries) 3 April 5th 07 07:16 PM
"formula is too long" AND test for whether double-quotes are next-to text or number?? The Moose Excel Discussion (Misc queries) 2 September 14th 06 05:29 AM
find/replace "cr" from end of number to "-" in front of number Dave o Excel Discussion (Misc queries) 2 August 22nd 06 09:24 PM
Formulae or format to change a number "1" into the word "one Excel Help Excel Discussion (Misc queries) 1 May 30th 06 04:25 PM
Format a column wihtout using "Format-Cells-Number-category-etc" serve Excel Worksheet Functions 4 February 24th 06 12:54 AM


All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"