( An Microsoft Excel Based software Application developer)
Click to learn Excel [Link]
த�ழ் : excel இல் cells format எப்ப� ெசய்வ� , பல்ேவ�பட்ட
format ெசய்�ெகாள்ளலாம் இந்த option பயன்ப�த்தி
English: We can format cells in different format as required by using
this option, When we format cells in Excel, we change the appearance
of a number without changing the number itself.
Format Cells
We can apply a number format (0.8, $0.80, 80%, etc) or other
formatting (alignment, font, border, etc).
1. Enter the value 0.8 into cell B2.
By default, Excel uses the General format (no specific number format)
for numbers. To apply a number format, use the 'Format Cells' dialog
box.
2. Select cell B2.
3. Right click, and then click Format Cells (or press CTRL + 1).
( An Microsoft Excel Based software Application developer)
The 'Format Cells' dialog box appears.
4. For example, select Currency.
( An Microsoft Excel Based software Application developer)
Note: Excel gives you a life preview of how the number will be
formatted (under Sample).
5. Click OK.
( An Microsoft Excel Based software Application developer)
Cell B2 still contains the number 0.8. We only changed the appearance
of this number. The most frequently used formatting commands are
available on the Home tab.
6. On the Home tab, in the Number group, click the percentage symbol
to apply a Percentage format.
7. On the Home tab, in the Alignment group, center the number.
8. On the Home tab, in the Font group, add outside borders and
change the font color to blue.
( An Microsoft Excel Based software Application developer)
Result:
For Application tools development Queries
Contact: Vijay
Write to: vijeemails@[Link],
Telegram / Dial to: +91 81 4727 1235