LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ravi Mohan Sahay
 
Posts: n/a
Default entering 16 digit number in Excel suffix 0 comes automatically

When I key in beyong 15 digits number in a cell of Excel 2000 or office XP
Excel eats up 16th digit and places a 0 and go-on like that.

Please help me
 
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
16 digit number wont keep alteration unless format cell to text Croc001 Excel Discussion (Misc queries) 3 March 30th 05 09:12 AM
How do I auto number cells in an Excel template? Natalie Excel Discussion (Misc queries) 3 March 30th 05 03:42 AM
Number of dropdown fields in Excel is limited. I need more. How? UweVahrson Excel Discussion (Misc queries) 7 March 28th 05 05:10 PM
Excel should let me circle a cell or number in the spreadsheet fo. BTaylor Excel Discussion (Misc queries) 2 March 8th 05 03:00 PM
How do I set up a field in an Excel form to number it incremental. max Excel Worksheet Functions 1 November 29th 04 10:33 PM


All times are GMT +1. The time now is 02:31 PM.

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"