Skip to main content

Featured Post

Changing Digit Grouping (Comma Style) in MS Excel - Million to Lakh

By
Well this is a very common problem for our sub-continent i.e. Bangladesh, India, Pakistan, Nepal, Maldives, Sri Lanka. Cause our digit grouping system doesn't match with the international system. To be more specific - they use million, billion etc. But we use - lakh (also lac), crore etc. 
Users of the mentioned regions often face problem with the comma separator position in MS Excel. Cause the default system is international. It doesn't suit our digit grouping system. 
International System - Separates every three digits 1,000.0010,000.00100,000.001,000,000.001,000,000,000.00
Subcontinental System - Separates every two digits after the 1st three digits
1,000.0010,000.00 1,00,000.001,00,00,000.001,00,00,00,000.00 
If you're familiar with the Indian Subcontinent system and if you're bound to use this system then it will be a big trouble if you don't know the solution. Well nothing to worry about as you are going through this article. Cause from the very next moment you'…
1 comment

How to Type More than 15 Digits in MS Excel?

Image
By



If you are a regular user of Microsoft Excel then you might be in danger while typing more than 15 digits in a cell. If you type 1111222233334444 then it will be 1111222233334440. Or if you type 25127680876675435 then it will be 25127680876675400. Simply the digits after 15th place will be changed to zeros! Doesn't it seem peculiar? 


Today I will explain when & why this problem occurs and how you can solve it easily. 


When the Problem Occurs?

The problem occurs when you try to type more than 15 digits in a cell like below: 

####-####-####-####
1234324545679876

But when you press Enter, the output will be 1234324545679870. Excel changes the last digit to a 0. And why someone needs to type more than 15 digits in a cell? It can't be a currency figure. 

Usually when you type a Credit Card/ Debit Card/ BO Account Number you have to type 16 digits. And the calculation of excel doesn't allow you to type more than 15 digits. That's why it converts the last digits (after 15th place) into zeros.  


Reason

You may ask - why Excel restricts users to type 15 digits in a cell? I'm also searching for a satisfactory answer. I found the following reason from Microsoft Support: 

Excel follows the IEEE 754 specification on how to store and calculate floating-point numbers. Excel therefore stores only 15 significant digits in a number, and changes digits after the fifteenth place to zeroes. 

I don't know what does it mean! :) Anyway, I can show you several ways to get rid of this problem . . . 


Solution

There are several ways through which you can avoid this problem. First I'd like to show you an easy way:

Method 1: Putting Inverted (') Before the Number

When you type more than 15 digits in a cell, just place an inverted comma ( ' ) before that number. And that mark will not be displayed on the sheet after pressing Enter! Though it will be displayed in the formula bar. Look at the image below: 


I don't know why the inverted mark disappears automatically. But I can explain why the 16th digit doesn't change to 0. Because when you type ' before a number then Excel doesn't consider this value as Number. It maybe consider the cell as text. That's why it remains unchanged. 


Method 2: Format the Cell as Text

Maybe the 2nd method is more useful. Before typing more than 16 digits in a cell, you have to format those cells as text. 

You need to select the cells first. Office 2003 users will find the Format Cell options from the Format Menu > Cells > Format Cells. And Office 2007 and 2010 users will get this as below: 


Format Cells Menu in Excel 2010


Format cell window is same in all version of MS Excel. After selecting the cells, you will just need to choose the Text option and then hit OK. That's it. 

Now you will be able to type more than thousand characters in a single cell! 


Applies to: 

All versions of Microsoft Excel. 


Stay with Marks PC Solution to get more interesting IT topics!

Reactions: Location: Dhaka, Bangladesh

Comments

  1. Kalpesh KalekarAugust 13, 2013 2:00 am

    In Excel, the floating point type is Double which is a IEEE 64-bit (8-byte) floating-point number. These can display 15 digit precision (well sort of, see the MSDN article Excel Worksheet and Expression Evaluation).

    The reason is the limited precision that can be stored in a floating point variable. For a complete explanation you should read the paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic", by David Goldberg, published in the March, 1991 issue of Computing Surveys.

    Another, more accessible site, is Chip Pearson's site.

    ReplyDelete
  2. AnonymousAugust 19, 2013 8:56 pm

    Nice Post

    ReplyDelete
  3. anujApril 26, 2015 9:11 pm

    Thank u

    ReplyDelete
  4. Sanjeev ZopfanSeptember 06, 2015 5:23 pm

    Similar to above discussion, my problem is thus:

    I want to type two mobile numbers in one cell of the excel with this cell/display format: #####-#####, #####-##### (means one hyphen after every 5 digits).

    But it keeps changing the last 4 digits into zeros.
    Is it possible in any way?

    ReplyDelete
    Replies
    1. Md. Abdur RahamanSeptember 06, 2015 6:43 pm

      Why don't just follow the 2nd method? Format the cell as text as shown in the image. Then you can type as many digits as you want . . . :)

      Delete
  5. UnknownJanuary 30, 2016 2:08 pm

    Thnk u but, after save as the reopen this one it's showing same format, it;s mean last number is zero

    ReplyDelete
  6. UnknownJanuary 30, 2016 2:09 pm

    Thnk u but, after save as the reopen this one it's showing same format, it;s mean last number is zero

    ReplyDelete
  7. UnknownJune 24, 2016 3:46 pm

    Before put any number in your sheet just right click select the row/column where you wanna put the numbers (more than 15 digit numbers)and choose format cells.... and choose text from the list and simply click on ok button than here you go... thanks.

    ReplyDelete
    Replies
    1. Md. Abdur RahamanJune 24, 2016 5:36 pm

      Yeah that's the short way. Thanks for the comment ...

      Delete

Post a Comment

Popular Posts

GTA San Andreas Cheat Code (PDF)

By
After Vice City, San Andreas is the most popular game released by Grand Theft Auto (GTA). Usually GTA releases role playing game. San Andreas is such a game where you can act like a person. You can do everything. You have to take part in missions and complete them. 
To make your missions easier, there are lots of cheat codes. If you can properly apply these codes, the tough parts of the game will be easier. Cheat codes are somewhat like keyboard shortcuts of computer programs. 

I've shared 63 cheat codes below. There were more cheat codes in my collection, but I've omitted the less important cheats. Effects or result of the cheats are on the left side, and the codes are on the right side. 

You can copy the following codes in your PC. And for your convenience, I've also uploaded a PDF file of these codes. You will find the download link at the bottom. 

EffectCheat CodeAdrenaline ModeMUNASEFAll Cars ExplodeALLCARSGOBOOMAll Cars Have NitroCOXEFGU or SPEEDFREAKAll Green LightsZEII…
7 comments
Read more

Office 2016 Activator (KMSPico 10.1.5)

By
It's been couple of months after the release of final version of Microsoft Office 2016. And maybe you're tired of finding for a working activator for this version. Today I'm gonna share Office 2016 activator with you - no more waiting!!

About the Activator Name: KMSPico 10.1.5File Size: 3 MB (Approx)File Type: Zipped Folder100% Neat & Clean - No virus!

Activating Capacity . . .
KMSPico 10.1.5 is successfully leading the KMS world for last few months. If everything is okay, success rate is 100%. This tool has been tested and verified by Marks PC Solution. With this tool, you can activate -  Office 2016, 2013 & 2010Windows 10, 8.1 & 8Hopefully this version will work for both 32 bit & 64 bit versions of Windows.








Installing Office 2016 Collect/ Download Office 2016 Professional Plus from Microsoft or somewhere else.Install it as trial version without any key.Use the following activator . . .

Download > Install > Enjoy . . . Get the file from here. The first link i…
193 comments
Read more

Office 2010 Activator (KMS) !!

By
Day by day cracking has been a tough job. But yet very possible. Earlier a software may require only serial key to activate. But today there are many other options. Sometimes you might be asked to connect to the internet to activate or sometimes you're asked to make a phone call! 






Microsoft Office 2010 has the same problem. It is not simply activated by the CD key. Sometimes CD key may not be asked during the installation process. If you're required to enter serial then try any of the following:



YF79C-7Y4B4-PGM89-6BKGJ-46PBT

FC7HF-CF42G-MX6D7-8K9T7-BT9QT

2PWHY-KT4X6-96PYW-XQR7V-HW2W9
PYMDW-8DFY2-Y68BB-XHDGD-CT443
7XD2X-JWJ94-BCHBW-W9WXP-J2WPT
P6RW8-B8X84-FFK73-4BPWM-KRHX3


After installing a trial version of Office 2010 you're allowed to use it for 30 days only. After that it will ruin your peace. It will give you continuous love messages each time you start office. Today I'm gonna share an activator by which you can activate Office 2010 and stop unwanted love messages by MS Of…
137 comments
Read more

Office 2013 Activator (KMSpico 10.1.5)

By
KMSpico 9.1.3 is really an amazing tool for activating Office 2013. And as a bonus, you can also activate Windows 8 or 8.1 with this activator. Earlier I shared different activators for Office and Windows. And those activators are working fine. If you can't activate your Office or Windows by those activators, then you can try this one. 





I've got Microsoft Office Professional Plus 2013 (final version) last week. And before that I was using Office 2010. After installing Office 2013, I was unable to use it before activating. And with this KMSpico 9.1.3 my Office gets activated within minutes. It's very easy to use! 






Furthermore, this KMS is capable of activating -  Windows 8 and 8.1 (All Versions) Windows Vista and 7 (Business, Professional & Enterprise Edition)Office 2010 and 2013Windows Server 2008/2008R2Windows Server 2012/2012R2

Activation Procedure: Download the KMSpico 10.1.5 from Here.Now double click on it. And follow the manual include inside.Press Next > Accept ter…
233 comments
Read more

Download GTA Vice City Cheat Codes (PDF)

By
Couple of years ago, GTA Vice City was one of the most popular game. GTA games are always preferred by the gamers. Most of the GTA games like Vicy City, Liberty City, San Andreas have cheat codes. With these cheat codes, you can complete missions easily. When something is very difficult to perform normally, you can use cheats. 

Here I'm gonna share 32 selected cheats with you. I've omitted the unnecessary cheats. And these cheats are also applicable for GTA Liberty City!


Press any of the below cheats while playing the game. The right part of the table contains the cheats and the left part contains the results. 

Effect
Cheat Code All Cars are FasterGet There FastArmorPrecious ProtectionBetter Driving SkillGrip is EverythingCaddyBetter Than WalkingCars Float on WaterSea WaysCars FlyAirshipCars FlyingCome Fly With MeClear Wanted LevelLeave Me AloneCommit SuicideI cant take it any moreDestroy All CarsBig BangFast CarGet There QuicklyFaster Game ClockLife is passing me byFaster Game Pla…
Post a Comment
Read more

IDM 7.2 Portable Free Download!!

By
There is nothing new to tell about Internet Download Manager (IDM). Most of you are familiar with this amazing download accelerator. But still people look for the cracked version of IDM. Version changes over time. And people try to get the new activated version. Today I'm gonna share IDM 7.2 (Portable) with you! 

Before I begin, I should declare that this is not a registered version of IDM actually. But the settings of this IDM are modified. You don't need to upgrade or register this version. After 30 days, you will not get the notifications to upgrade. And you will enjoy all the advantages just like a registered version. 
But there is nothing to worry about. You can download this portable version of IDM without hesitation. It's just 4.7 MB. You don't need to install it. This version will never demand serial from you. And the download link is 100% free from ads, spams or malware.


Downlaod IDM 7.2 Portable either from Link 1 or Link 2. Unzip the folder and move it to your …
32 comments
Read more

Rules for Bengali Typing in PDF (Bijoy Layout)

By
Bijoy is the most popular layout for Bangla typing. The layout was developed by Mostafa Jabbar. He is the pioneer of Bangla typing in computer. More than 90% people use his Bijoy layout for Bangla typing.

Today, I'm gonna share a PDF file with you that contains the Bijoy Keyboard layout with English fonts! If your keyboard doesn't have bengali fonts then you can print this PDF file to know where the bengali fonts are located in your keyboard. Additionally this file contains all the necessary rules and tips which are essential for Bangla Typing. 


Now there are many other software available for Bangla Typing Layout. Such as Avro Easy, Unicode, Unibijoy etc. And there rules are also somewhat different from Bijoy. And some of their layouts follow the same rules like Bijoy. Hopefully this PDF file will support most of the rules when a layout is similar to Bijoy Layout. 





 Download the PDF file from the button below. Follow my instructions properly. And I can guarantee you will be able t…
8 comments
Read more

How to Disable Word Verification (Captcha) in Blogger Comment

By
By default blogger blogs are designed to show word verification when visitors comment in a post. Though this is a very useful tool to avoid spam, but real users often get bored by this option. Besides blogger has an automatic spam checking tool. So you can remove the word verification option from the comment in order to let your visitors express their opinion easily. 
While commenting on blogger blogs or other websites you may face a word challenge. And this is a very common thing. Specially when you open any online account. Sometimes words used in the verification option are too hard to guess. And users are very annoyed with this. 


Look at the image above. When you comment on blogger blogs or someone comments on your blog he/she will face a challenge like this. Normally this option doesn't show any hard challenge. But sometimes they are also difficult to guess. Users have to try this again and again. If they are annoyed they will loose interest to express their opinion. 

Since blogg…
30 comments
Read more

How to Check Cell Phones Quality Using IMEI - *#06#

By
Most probably, mobile phone is the most used device by the people throughout the whole world. Couple of years ago the use of mobile phone was very limited. But today many users have more than one or two mobile phones.
And to meet the demand, manufacturers are producing their products in different places to reduce the cost. Sometimes mobile phones are produced in China, India or any other country where production cost is relatively low. And quality is also hampered for this reason.
So, in this post I am gonna show you, how do you check your mobile phone's quality using the IMEI number. 
IMEI stands for International Mobile Equipment Identity. It is a 15-digit number and may be found in the packet of the mobile phone. It may also be found by removing the back cover and it may be placed on the battery sticker. 
If you lose your IME number then you can find it by typing *#06# on your mobile screen. After pressing this code, you will see a 15-digit number immediately on the screen which is…
166 comments
Read more