Using the format code “0000000” means that the value in the cell would always be seven digits long. If you need five-digit numbers with leading zeros, we have to enter five zeros within quotes. Since we need seven-digit numbers with leading zeros, we have to enter seven zeros within quotes (“0000000”) for this argument. Here we have to give the format code that we need to apply to the selected number. We have to select the number that we want to convert. The first argument of the TEXT function is the value. The syntax of the TEXT function is TEXT(value,format_text). The TEXT function helps to convert a number to text by applying a format code to that number.
0 Comments
Leave a Reply. |