filmov
tv
How to use TEXT function in Excel | Excel Tips
Показать описание
How to use TEXT function in Excel | Excel Tips
TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This function is useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. For example, suppose cell A1 contains the number 23.5. To format the number as a dollar amount, you can use the following formula:
Syntax: TEXT(value, format_text)
TEXT function converts a numeric value to text and lets you specify the display formatting by using special format strings. This function is useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. For example, suppose cell A1 contains the number 23.5. To format the number as a dollar amount, you can use the following formula:
Syntax: TEXT(value, format_text)
0:10:11
0:05:45
0:09:49
0:00:25
0:00:25
0:04:21
0:00:31
0:00:34
0:00:42
0:03:52
0:00:20
0:00:24
0:03:32
0:01:16
0:13:05
0:18:23
0:00:19
0:09:24
0:05:19
0:04:30
0:00:27
0:00:06
0:00:26
0:04:56