Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 148
Default Big number error


6018971032413880
That number is a big number but why is it if I try to chage the last zero to
a 3 while in Excel, the zero always comes back as soon as I hit ENTER

Thanks

  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,268
Default Big number error

Look up specifications in Help and you'll find it's not an error, Excel have
15 digits of precision,
everything beyond that will be truncated. Assuming you have credit card
numbers or account numbers just precede any entry with an apostrophe or
pre-format the cells(s) as text


--


Regards,


Peo Sjoblom


"pcor" wrote in message
...

6018971032413880
That number is a big number but why is it if I try to chage the last zero
to
a 3 while in Excel, the zero always comes back as soon as I hit ENTER

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 148
Default Big number error

Thanks for that important info

"Peo Sjoblom" wrote:

Look up specifications in Help and you'll find it's not an error, Excel have
15 digits of precision,
everything beyond that will be truncated. Assuming you have credit card
numbers or account numbers just precede any entry with an apostrophe or
pre-format the cells(s) as text


--


Regards,


Peo Sjoblom


"pcor" wrote in message
...

6018971032413880
That number is a big number but why is it if I try to chage the last zero
to
a 3 while in Excel, the zero always comes back as soon as I hit ENTER

Thanks




Reply
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 2007 printing error: "The number must be between 10 and 400. Boris Excel Discussion (Misc queries) 1 July 30th 07 08:30 PM
error while copying number from Notepad vipul Excel Discussion (Misc queries) 2 May 1st 07 11:42 AM
Number Stored as text Error Torero Excel Worksheet Functions 2 December 1st 06 01:28 PM
Counting the number of Error Types Bob Excel Worksheet Functions 3 November 16th 06 06:01 PM
Error: Number of query values and destination fields are not the s Secret Squirrel Excel Worksheet Functions 0 December 3rd 05 02:26 AM


All times are GMT +1. The time now is 06:00 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"