If you see there are pre defined number format options available when you choose cell format option, however you can use custom format option if available formats does not server your requirement.
There are four sections of format codes. The sections are separated by semicolons ";" First section defines the formats for positive numbers; Second section defines negative numbers; third section defines how to show zero values; and forth one define how to diplay text. If you specify only two sections, the first is used for positive numbers and zeros, and the second is used for negative numbers. If you specify only one section, all numbers use that format. If you want to skip a section, include the ending semicolon for that section.
# displays only significant digits and does not display insignificant zeros.
0 (zero) displays insignificant zeros if a number has fewer digits than there are zeros in the format.
? adds spaces for insignificant zeros on either side of the decimal point so that decimal points align.
? can also be used for fractions that have varying numbers of digits.
How to add a superscript in Custom Format
ReplyDeleteHi Jas
ReplyDeleteSuperScript can be handled through macros, request you to be specific about what do you actualy need.
Thanks
Please suggest a format to display numbers in Indian number system 0,00,000.00
ReplyDeleteHello JPC
ReplyDeleteYou can try following custom format
[>=10000000]#\,##\,##\,##0.00;[>=100000]#\,##\,##0.00;##,##0.00
hello sir
ReplyDeleteI want to know the process to change the digit in words in nepali format in MS excell. Please help me. my email Id is ry3178@gmail.com