Can Excel show the decimal fraction without the leading zero and following zero?
Can Excel show the decimal fraction without the leading zero and following zero? And I want the method can be like “general” in custom of the cell format, that is the number of digital following the point can be dynamic. Enter .## is still not a good way because the number of digital following the point is fixed to 2.
For example, I want 0.56 shows as .56; 0.7898790 shows as .789879
2008-06-26T11:28:25Z
Let me make it clear in this way: For example: in cell a1, I have 0.5 and in cell a2 I have 0.9987. I want to find a same cell format for these two cells and get .5 and .9987 separately.
2008-06-26T11:43:45Z
Please note that I tried this method: set a Custom format of .# (decimal point and # sign). It can not satisfy my requirement because how many # you type will fix the number of the figure after the decimal point. I want the number of the figure after the decimal point is dynamic.
garbo74412008-06-26T11:27:06Z
Favorite Answer
It can be done via Format>Cells. You can set a Custom format of .? (decimal point and question mark)
I just used your example to create the scenario before answering the question adn tried multiple ways to try getting it solved.
Sorry, but I don't think this can be done the way you want it.
To format cells, you have to highlight the cells you want to format then on your top menu, click on your FORMAT then CELLS then select the NUMBER tab.
If you have 0.56 in one cell and 0.7898790 in another cell...
1) the digit 0 is going always show up before your decimal point...can't get around that.
2) if you format all your cells for 1 or 2 decimal places, then .56 will show up as 0.56 and .7898790 will show up as .079 because of the cells being formatted for 2 decomal places and the program automatically rounds up to the next number if your 3rd digit you entered was 5 or higher.
If you want various lengths of decimal places, you have to format the cells to be GENERAL. If you have many digits in your decimal number and don't see all the digits in the cell, your column needs to be resized to compensate.
To resize your column, go to the top of your column heading, put your cursor over the right edge until you see an arrow pointing left and right with a little verticle line in the middle. Double-left click and your column will resize appropriately.
Bottom line though is...unfortunately you can not get rid of the zero before your decimal point.
Hi Alison, To get the required number of decimal representations on the excel sheet, you need to select a particular cell on the excel sheet. Right-click the mouse. Go to the format cell option. There will be tabs like: Number, Alignment, Font, Border etc. By default Number tab is always pre-selected screen. In the Category box, click on Number. On the right side of the box, there will be drop down called Decimal places. Based on the maximum number of decimals which you have in the datasheet, select the value of decimal places. You will able to see the increase or decrease in your selection on the Negative Numbers box on the same screen. Once you have selected the number of decimal places as required by you, click Okay. Viola. You will have the desired result.
A quick update seeing as how this post is eight years old:
The custom format #.0### (as many decimal places as you want) works to remove the leading zero for fractions less than one, or to include the first whole digit for fractions greater than one.
Click on format from the menu and then cells. Click on 'number' and you'll see a box on the right side where you can increase the number of decimal places.