Large integers in excel 2003 are rounded ?? Is this a BUG ?－software｜痞客邦

Mar 09 Fri 2007 20:36
Large integers in excel 2003 are rounded ?? Is this a BUG ?

close

Excel only has 15 digit precision. That is why when entering a 16 digit
credit card number, you would format it as text.

quot;Mike Onequot; wrote:

gt; Format a cell as number and set decimal places to 0.
gt;
gt; Then enter 1818181818181818 in a cell and hit enter...
gt;
gt; Excel then CHANGES to the number to:
gt;
gt; 1818181818181810 ???? WHAT ???
gt;
gt; This can't be right can it ??, what am I missing ?

software

software

software 發表在痞客邦留言(0) 人氣()

E-mail轉寄

全站分類：不設分類
個人分類：title
此分類上一篇： Data Broadcasting in Excel
此分類下一篇： DAVERAGE criteria HELP!!!!
上一篇： Advanced Filter
下一篇： how do I calculate the time service minus holidays?

歷史上的今天

2007: Row height/column width
2007: excel quot;Networkdayquot; function
2007: Group amp; Stacked Chart
2007: Data Validation
2007: Creating ODBC link within SELECT statement
2007: Excel recalculates on startup?
2007: new copy of spreadsheet using old spreadsheet info.
2007: How do I count letters and numbers in a formula?
2007: update cells to today date in a list of dates
2007: exel conditional formula,calculate a bilateral tolerance(.2/-.2)?
2007: Counting Cell with Quotation
2007: Protection of identical cells on multiple worksheets
2007: How do I which file in collection is being used in the calculation
2007: getpivotdata function
2007: Sum up a particlar cell in multiple Excel worksheets within same b
2007: References to Blank Cells turn into Zeros
2007: How do I delete lt;brgt; or lt;bgt; that appears in text?
2007: how do i copy just the data and not the formula in a cell?
2007: Conditional Formatting I can't seem to figure out......
2007: Can I filter cells by color?
2007: IF formula for 13 plus variables
2007: Option Box Run Time Error Cell Locked
2007: How to feed the contents of a cell as row index?
2007: Linking Large Access Table into Excel
2007: Remove the quot;Falsequot; from Statement
2007: MRound
2007: countif, sumif, sumproduct
2007: hiding content when there is a #REF in a cell
2007: How do I change the format/cell/border/automatic color to black
2007: How do I get multiple matches when using the Vlookup function?
2007: What does the second parameter in ACCRINT do?
2007: HOW DO I USE EXCEL FOR QUALITY CONTROL CHART SUCH AS TEMPERATURE .
2007: Summing a range with conditions
2007: How do I create a running total (balance) in a pivot table?
2007: Convert Seconds and decimals to time
2007: Labels responsive to cell values
2007: Strange problem....excel not responding
2007: Autosum refreshing
2007: Polynomial equations
2007: Data Valitaion Input message
2007: getting combinations
2007: How do I combine 2 COUNTIF formulas??
2007: vlookup question
2007: Adding or combining time problem.
2007: HELP
2007: not copying correct value
2007: Excel Formulas
2007: headers on excell worksheets
2007: Excel formula to increment the month by 2?
2007: Automatic extend row in workshet.
2007: Split a Value
2007: Advanced Filter Question
2007: Combining LEFT\IF and Concatenation
2007: size limitations on auto filter
2007: Forms controls
2007: How do I keep Excel in manual calcuation?
2007: Scheduler and passwords
2007: How can I seperate the demensions from the description?
2007: Adding relevant sheets
2007: Copy/Paste Rows that Contain Specific Text
2007: 1-9 not as a date
2007: How can I lookup a cell that's to the left?
2007: when I enter an amount in the A column move the row to another she
2007: Legend Modification
2007: delete a check box
2007: Damaged software
2007: The Formula is Too Long
2007: Data Entry Form and List
2007: Excel Help Needed......
2007: extract year from the date in a cell
2007: Depriciation Matrix
2007: VLOOKUP
2007: How do I create template fields?
2007: In Excel, how do I make the same changes to different values?
2007: Inserting Picture in protected sheet
2007: printing worksheet on 3x5 card
2007: Matching List Entries
2007: Normal distribution test in excel?
2007: Excel showing a row of ##### in stead of dollars, but when
2007: Help finding and summing across worksheets
2007: How do I insert an excel spreadsheet in Word?
2007: sequential numbers
2007: auto format help
2007: =bahttext(A1) please tell me about language in english how can i
2007: how do I calculate the time service minus holidays?
2007: Vlookup always gives me #NA
2007: nonadjacent selections
2007: How do I create an quot;outline summaryquot;
2007: how to compute a range of cells based on another range of cells?
2007: Iteration
2007: Formatting Question
2007: Workbook_Open() Event
2007: Can I set up a newsletter style column in Excel?
2007: sum stopped calculating
2007: Find amp; Copy Data query
2007: PRINTING
2007: DAVERAGE criteria HELP!!!!
2007: Data Broadcasting in Excel
2007: row that needs to wait till the next page break befor copying
2007: Creating Charts

留言列表

站方公告

活動快報

newdirect

看更多活動好康

我的好友

熱門文章

文章分類

最新文章

最新留言

動態訂閱

文章精選

所有文章列表

文章搜尋

新聞交換(RSS)

誰來我家

參觀人氣

本日人氣：
累積人氣：

QR Code

qrcode

POWERED BY

(登入)