Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How you can use Number format options in Excel?

user-image
Question ajoutée par Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
Date de publication: 2013/12/02
Zafar Iqbal
par 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®
par 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
par 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
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?