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: 10
Default New rounding problem in Excel 2003?!?

We're seeing a problem in Excel that I've never come across. All of the
machines that we're seeing this on just downloaded this month's auto-update,
but I haven't looked yet to see if there were any Office fixes. I'm
wondering if any of you are seeing this or might have a solution for me.

We typically work with 16-digit credit card-style numbers, where the entire
number is treated as text. Typically, trying to format the number as text
results in scientific notation, so I usually leave it as a number with no
commas or decimals. However, no amount of formatting seems to affect this
issue.

When I enter a number in to a cell, if it is longer then 15 digits, any
number after 15 changes to a zero. You can see in the example I've pasted
below where I was typing in all 4's ending with a 3, from 2 digits to 17
digits long. Even if you go to edit the data, the last numbers have been
changed to a 0, it's not just how the formatting is showing the number.

43
443
4443
44443
444443
4444443
44444443
444444443
4444444443
44444444443
444444444443
4444444444443
44444444444443
444444444444443
4444444444444440
44444444444444400

Am I missing something? Help!

Thanks!!
beth

 
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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Excel 2003 hyperlink problem. rockbottom Excel Discussion (Misc queries) 0 December 1st 05 05:02 PM
problem with column charts and two Y axes in Excel 2003 napofrog Charts and Charting in Excel 1 October 21st 05 03:04 AM
EXCEL 2003 PROBLEM Amandle Excel Worksheet Functions 4 April 1st 05 02:25 PM
Excel 2003 Filter Problem bkbrueggemann Excel Discussion (Misc queries) 3 February 1st 05 11:49 PM


All times are GMT +1. The time now is 06:17 PM.

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

About Us

"It's about Microsoft Excel"