ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

How you can use Number format options in Excel?

user-image
تم إضافة السؤال من قبل Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor
تاريخ النشر: 2013/12/02
Zafar Iqbal
من قبل 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®
من قبل Mohammed Yaseen MBA PMP® , Project Controller , Hayat Communication (www.haytacommunications.com)

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
من قبل Jayson Aglubat , Graphic Designer/Information Technology , Local Government

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
من قبل 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... :)

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟