#1   Report Post  
muckali
 
Posts: n/a
Default 15 digits???

I was just noticing that I can not enter more than 15 digits in a cell, the
16th always changes to zero. Why is this, and is there any way to fix this?

All sugesstions are welcome, but I also want to keep it in the format of
"0000 0000 0000 0000" I've been doing this by making a custom format.

Thanks a lot!!!!
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

It has to be text. A number can have only 15 decimal digits. Either
precede it with an apostrophe ('), or pre-format the cell (Format - Cells -
Number tab) as text.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"muckali" wrote in message
...
I was just noticing that I can not enter more than 15 digits in a cell, the
16th always changes to zero. Why is this, and is there any way to fix
this?

All sugesstions are welcome, but I also want to keep it in the format of
"0000 0000 0000 0000" I've been doing this by making a custom format.

Thanks a lot!!!!



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
Least number of digits in Y-axis labels Charley Kyd Charts and Charting in Excel 9 February 6th 05 03:03 PM
How do I format cells to a specific number of digits? Gabriele Excel Discussion (Misc queries) 3 February 5th 05 03:17 PM
Using a IF formula, I would like to drop the 2 digits in front of. osuhoosier Excel Discussion (Misc queries) 2 January 6th 05 08:21 PM
Function in XL or in VBA for XL that pulls numeric digits from a t Nate Oliver Excel Discussion (Misc queries) 0 December 14th 04 04:57 PM
I have a col. with 6 digit nos to convert to 3 cols of 2 digits Brian Excel Discussion (Misc queries) 4 December 3rd 04 09:21 PM


All times are GMT +1. The time now is 10:59 AM.

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"