The TEXT function allows you to change the appearance of a number by using format codes to apply formatting to it. It comes in handy when you need to present numbers in a more understandable style or when you want to blend numbers with text or symbols.
Make a selection of the cells you want to format.
Click the arrow in the Number category on the Home tab.
In the Category list, select Custom, and then select a built-in format that looks similar to the one you desire.
A text string, usually referred to as a string or just text, is a collection of characters used as data in a spreadsheet software. Words make up the majority of text strings, although they can also include letters, numbers, special characters, the dash symbol, and the number sign.
When concatenating a formatted number to a text string, the TEXT method comes in handy. "Sales climbed by over $43,500 last year," for example, where the figure 43500 has been represented with a currency sign and a thousands separator. The number formatting will be stripped if you don't use the TEXT function.
Cells should be selected-> From the Number Tab of Format Cells, press Ctrl+1. Choose "custom" from the drop-down menu and paste it into the Type edit box below.
Learner's Ratings
4
Overall Rating
56%
21%
6%
6%
11%
Reviews
N
Nitesh kumar gupta
5
nice course all the video explained very well from scratch to advance
S
Shubham Maurice
5
Overall Lectures are good but also provide the practicing spreadsheets for students.
S
Shivam Gautam
5
very good experience
K
KALAGA NARAYAN
5
i dont think some one can explain deeply ,practically rathere than this tutor
L
Lavkesh Kushwaha
5
West
K
Kamran Ahmed
5
Helpful course
S
sanjeet kumar
4
some excercise should be there. I have not studied standerd deviation of population in second module but question has been asked.
V
Vishisht
5
good
S
Shringa A G
5
This is a really helpful course for beginners as well as experts. You can develop your skills from this course.
Share a personalized message with your friends.