Now we will see that how we can format numbers in MS Excel.
On our sheet we have some numbers as salary and mobile number, if we want to get our salary in an accurate format we can get it by going into the 'Format Cell' number dialogue box and select the number's format as per our requirement.
By using format sales we can easily get our data with currency.
See More
The best way to format numbers in Excel depends on the column type. Numbers in text columns should be formatted as text, while numbers in number columns should be formatted as numbers.
The most straightforward way to format numbers in MS Excel is to use the Format Cells dialog box. In this dialog box, you can select the number format that you want from the Number tab and then apply it to all cells or a selected range of cells.
Learner's Ratings
4.4
Overall Rating
69%
20%
6%
3%
2%
Reviews
K
Keshav dev Saini
5
Sir mujhe Excel ke all pdf notes chaiye pls send kardijiye
K
Kanika Garg
5
Understandable and easy explanation
R
RUPINDER KAUR
5
The course is straightforward for beginners to learn, and the tutor's voice is clear. However, we have some questions, such as how to use the keys on our laptop that aren't working, need help.
Mohd Asif Shaikh
5
Course is presented in simple and easy standard. But there is a mistake in Absolute video, the percentage option is not selected by the user so it is calcucate in mutiple option instead if percentage.
S
Supriya Sood
5
Very useful course and understanding easily all the things
M
Muhammad Faizan
5
I am really enjoying Learning from this platform, thanks
M
Mahesh yadav
5
very nice
P
Priyanka Jadhav
5
best
K
Karan Baghel
5
nice
M
Mohammed Zameeruddin
5
This is a valuable course that explains almost everything.
Share a personalized message with your friends.