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
L
Leela G
5
Nice teaching, Easy to understand
R
RAHMAT AZIZ
5
yes this is amazing platform
R
RAHUL KATHAD
5
10
B
Bilal Ahmad
5
I am very happy to this curse
A
abubakar taj
5
I am very happy to this course
M
Muhammad Jan
5
The Ms Excel course is very easy to understand there are good teachers in the web.
if the certificate policy can change its very good for poor users.
S
srinu muskari
5
Sir please provide this course in English and telugu languages also..kindly accept my request
S
Suprabhat Sharma
5
Easy to understand.. Thank you so much for providing this kind of course without any cost
S
Sachin shakya
5
Im very happy, I'm learning excel in learnvern.com
Share a personalized message with your friends.