Comments on: How to format cells in Excel (number, text, scientific notation, etc.)

When it comes to formatting cells in Excel, most users know how to apply basic text and numeric formats. But do you know how to display the required number of decimal places or a certain currency symbol, and how to apply just the right scientific notation or accounting number format? Continue reading

Comments page 2. Total comments: 61

  1. How to write 3-57 in excell, it shows March 57. Pls help

    1. Hello!
      If I understand your task correctly, the following formula should work for you:

      =TEXT(A1,"mmmm yy")

      You can learn more about TEXT function in Excel in this article on our blog.

    2. Hi Premika,

      First, set the cell's format to Text, and then type 3-57 in it.

  2. hello, What formulas can i use for number format if you have a cell or column that 1 through 28 b-c = d thanks

  3. Hi,
    Can any one help me to convert scientific notion to the general number for 6.15E+11.
    I tried it is giving 615000000000. But this not the right answer.

    1. Hello Manjunath!
      So that I can help you, explain what answer you think is right. I would recommend just using a number format.

  4. How do you format a scientific number to a general number? I have occurrences in a spreadsheet and every time I click in the cell I can see the general number on the formula line but in the cell the scientific number still appears.

    1. Hi Leslie,

      Just set the Number format for that cell:

      1. Select the cell(s), and then open the Format Cells dialog box (Ctrl+1).
      2. On the Number tab, select Number under Category.
      3. Specify how many decimal places you want to show in a cell and click OK.

  5. hI. I AM IMPORTING DATES OF BIRTH TO AN EXCEL DOCUMENT AS TEXT BECAUSE THE CVS SPREADSHEET I AM IMPORTING TO IS SET UP THAT WAY. WHEN I CHANGE THE FORMAT OF A CEL TO TEXT AND TYPE 1/1/2000 IT CONVERTS THE CEL BACK TO A DATE CEL AND I CANNOT UPLOAD MY DATA. CAN YOU HELP?

  6. nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.

  7. how to convert 100 excel files into the general category format with 1 click?
    please help me with a code

  8. -602.11
    How do to removed from excel

  9. In my Excel sheets, I usuall have a large number of large integer values. Usually, it is a hassle to go "Numbers format", scroll down to "other", check the thousand separator box, and klick twice on the number of decimals, and then press OK. I was very happy to find above the shortcut to set a format with a thousand separator and two decimals, since it will remove several steps from the above, but I still need to press the tool bar button for "fewer decimals" twice. Is there any way to get Excel to have 0 decimals and thousand separator as a default?
    BTW, I am a happy customer of Ablebit plugins, the merge tables function has saved me many days of tedious work!

  10. nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.

  11. Unfortunately still I'm helpless.... Can anyone of u consider my problem above? plsease

  12. Hi. please consider my problem. I linked a master sheet (some ranges of cells) with many other sheets (with the same cell references) using arrays. However some functions are not working in the Master sheet within the linked cells where the data from others sheets are automatically updated. For instance, sum function doesn't work with these linked cells. Any ideas?plsease

  13. Just a tip regarding the Custom number format - if you have a cell or column that requires a certain number of digits, enter that many zeroes in the "Type" box. If the number is less than that number of digits, it will add leading zeroes to the number. For example, type set to ten zeroes (0000000000) and entry of number 123456 will display as 0000123456.

    This also works for long number strings too, where Excel tries to display the number in scientific notation. I often work with 12-digit numbers, and entering 12 zeroes in the type makes Excel display the full number in the cell.

  14. how to covert Hijri date to Gregorian date. please give me correct formula for excel 2010. Example : 12/10/1437 output in Gregorian ????

      1. i have the vb codes but need sample formula witch is did easy.

      2. Dear,
        i try but not working......
        any way thanks for cooperation.

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)