Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How you can use Number format options in Excel?

user-image
Question added by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date Posted: 2013/12/02
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

We use number format in excel for different calculations but specially to fix the decimals of answers after the calculations in short.

Mohammed Yaseen MBA  PMP®
by Mohammed Yaseen MBA PMP® , Commercial Officer , Hayat Communications

Changing the alignment of data can make it easier to find and read important information in a worksheet.

 

By default, in Excel, numbers and formulas are right aligned in a cell while text data - such as headings and labels are left aligned.

The easiest way to change the alignment of data is to use the alignment icons on the Home tab of the ribbon.

 

Steps : formet > cells > Formet cells > NUMBER and select Category

you can set here > Text alignments, Text controll (like text wrap) and right center  right alignments.

OR

Simply press Ctrl+1  for Format cells> NUMBER  and follow instructions

Jayson Aglubat
by Jayson Aglubat , Creative Artist , Sadeem International Co.Ltd.

On home menu bar, go to standard tool bar which is number there is a dropdown list click the arrow to show the drop down list and have a an option of number formats to be select.

Jayaraj MS
by Jayaraj MS , Manager - Digital Marketing , FOURTISEVEN Digital Marketing

Right button>>Format Cells>>Number

Here you are.....

select which format you wnat to use for your cells... :)

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.