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%
19%
6%
3%
3%
Reviews
K
Karan Baghel
5
nice
M
Mohammed Zameeruddin
5
This is a valuable course that explains almost everything.
M
Md Sahal Al Ibrahim
5
This is a valuable course that explains almost everything.
H
Haider Ali
5
I never saw this type of course. Such incredible modules you added, every video is this worthy, because many courses' videos are worthless, we could learn nothing at the end.
M
MD SHAKIR
5
VERY HELPFUL
P
Prashant Sharma
5
start learning with learnvern
G
Ganesh kachare
5
Very good course
A
ABDUR REHMAN
5
Hint for the excel assignment 9?
M
Mahnoor
5
Which excel version is used ? Kindly tell me because i want to download it. I saw very first video which is quite easy and understandable.
Share a personalized message with your friends.