The Excel TEXT function is a function that converts a value to text in a specified format.
Syntax of the Text function is
A number format is a special code to display the value in the desired format. It changes only its display without changing the original data. This is very useful for automating formatting.
There are many Build-in formats present in excel. I have used some build-in formats, you can use any of the formats.
Syntax of the Text function is
=TEXT(value,format_text)
A number format is a special code to display the value in the desired format. It changes only its display without changing the original data. This is very useful for automating formatting.
No comments:
Post a Comment