LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default CELL IS NOT ACCODATING MORE THAN 12 NUMBRS HOW TO ENTER 15 DIGIT

I AM NOT ABLE TO ENTER MORE THAN 12 DIGITS I .E. 123456789012
THE CELL DOES NOT ACCOMMODATE - AFTER ENTERING: 123456789012345678
THE RESULT SHOWN IN CELL IS : 1234567E+15
HOW TO SOLVE THIS PRIOBLEM
 
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
How to enter more than 20 digit numbers in one cell Prasad.Sakharkar Excel Discussion (Misc queries) 2 August 9th 07 04:12 PM
can't enter a num. in xl cell, which is more than 16 digit or lon SUbodh Jain Excel Discussion (Misc queries) 1 December 21st 06 01:38 PM
Color a single digit in a mult-digit number cell Phyllis Excel Discussion (Misc queries) 6 November 17th 05 12:46 AM
how can I enter a 21 digit number in a cell & keep it from change alex Excel Discussion (Misc queries) 2 November 4th 05 10:24 PM
When we enter a 16 digit number (credit card) the last digit chan. ceking Excel Discussion (Misc queries) 5 December 8th 04 11:45 PM


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