How to Put or Write a Large Number in Excel – Quick and Easy (Example)

Excel is a powerful and versatile tool. It has many applications and details with which you can do endless things like create dynamic tables, manage rents and many other things; in fact experts say that with Excel you can do almost anything, even programming, using advanced tools such as macros.

Have you found that you want to enter the number of an account or a credit card, for example, and Excel does not accept it? What happens is that Excel tends to shorten the figures. Well, in this tutorial we are going to teach you how to put or write a number in Excel easy and fast in the cell or range of cells you need.

First procedure to put or write a large number in Excel

Next we will give you an easy and fast procedure, but in advance we will tell you that this first procedure helps you to enter these numbers as texts, and it will not help you to carry out mathematical operations or calculations. We understand then that it will help you to enter data such as account or credit card numbers and so on.

  1. First you must open a spreadsheet in Excel. Then you enter the data that you need to work on and if you are in the cell that gives you problems with the number that is large or with many figures, the quick and easy way to write that large number is the following:
  2. You put the colon symbol (:) and then you write the big number you want so that Excel will not shorten the number in question.

big number in excel

Now, if what you want is to perform mathematical operations with large numbers, the procedure changes; Then we will tell you why and we will describe it to you.

Second procedure to write a large number in Excel

Excel supports up to 15 digits in a large number, from there Excel apply an exponential notation format or scientific. This means that it abbreviates the notation of numbers to facilitate mathematical operations with very large quantities.

So, since Excel by default has like General initial cell format, this makes the program decide by itself to apply the format it deems appropriate for the entered figure. To avoid the problem that the exponential or scientific annotation format creates, apply the Number format to the cell where you will enter the figure, this gives you a working margin with numbers of up to fifteen (15) digits.

You can decide the number of decimal places within the Number format. Once there, in Category you choose Custom and in Type you choose the number of decimal places you want. But if you don’t want to have decimals, you choose zero (0). All this you can do as seen in the image below.

example excel high format number

Supposing that you need to create a database of telephone numbers, then you could choose the range of cells where you are going to locate them and in the category Custom of the format NumberInstead of zero you can put 00-000-0000000, assuming you were working with the country code, the area code and finally the phone number.

Now, if what you want is to do operations with very large integers, you already have to resort to programming with the VBA language and that can be taught in another tutorial. As you can see, Excel is a versatile tool, but although it has its limitations, it offers you many possibilities, such as creating dynamic tables.

Are you a small businessman and want to create your invoices in an easy way? With Excel you can do it without any problem. And when you start to invoice large quantities, with these procedures that we gave you, you will be able to work without major headaches. So cheer up, following our tutorials you will get a lot out of Excel.

Source by

Deja un comentario