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
How to write 3-57 in excell, it shows March 57. Pls help
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.
Hi Premika,
First, set the cell's format to Text, and then type 3-57 in it.
hello, What formulas can i use for number format if you have a cell or column that 1 through 28 b-c = d thanks
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.
Hello Manjunath!
So that I can help you, explain what answer you think is right. I would recommend just using a number format.
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.
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.
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?
nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.
how to convert 100 excel files into the general category format with 1 click?
please help me with a code
-602.11
How do to removed from excel
Hello,
Please specify what exactly you want to remove from Excel.
I'll try to help.
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!
nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.
Unfortunately still I'm helpless.... Can anyone of u consider my problem above? plsease
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
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.
Thank you for this tip, Mikey!
You can find a few more here: Custom Excel number format
how to covert Hijri date to Gregorian date. please give me correct formula for excel 2010. Example : 12/10/1437 output in Gregorian ????
Hello Abas,
Sorry, I don't know how to do this using a formula. Most likely a macro is required. You can try the sample code from this link:
https://www.excelforum.com/excel-programming/572150-gregorian-date-from-hijri.html
Also, you can check out this thread and download a sample workbook with a macro that converts Hijri dates to Gregorian:
https://www.excelforum.com/excel-general/791099-convert-from-hijri-date-to-gregorian.html
i have the vb codes but need sample formula witch is did easy.
Dear,
i try but not working......
any way thanks for cooperation.