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.
Nitesh kumar gupta
nice course all the video explained very well from scratch to advance
Overall Lectures are good but also provide the practicing spreadsheets for students.
very good experience
i dont think some one can explain deeply ,practically rathere than this tutor
some excercise should be there. I have not studied standerd deviation of population in second module but question has been asked.
Shringa A G
This is a really helpful course for beginners as well as experts. You can develop your skills from this course.