Follow these steps to use the TEXT function in Excel:
- Open your Excel Sheet.
 - Select the cell where you want the result to appear.
 - Type 
=TEXT(value, format_text)into the cell. - Replace the 
valuetext with the cell that contains the value you want to convert. - Replace the 
format_texttext with the format you want to apply. - Press Enter.
 
