Convert Number to Text | Convert Number to text in Google sheet How to add Zero before number excel
Please join us in our online live Class from below link :
https://sites.google.com/view/tanvira...
Download working file from below link :
https://docs.google.com/spreadsheets/...
To convert a number to text and add a zero before the number in both Excel and Google Sheets, you can use similar approaches. Here are the steps for each:
Excel: Convert Number to Text and Add Zero
Assuming your number is in cell A1, you can use the TEXT function along with concatenation (& operator) to add a zero before the number:
excel
Copy code
="0"&TEXT(A1, "0")
This formula will convert the number in cell A1 to text and add a zero before it.
Alternatively, you can use the CONCATENATE function:
excel
Copy code
=CONCATENATE("0", TEXT(A1, "0"))
Google Sheets: Convert Number to Text and Add Zero
In Google Sheets, the process is similar. Assuming your number is in cell A1, you can use the TEXT function along with concatenation:
excel
Copy code
="0"&TEXT(A1, "0")
Or, you can use the CONCATENATE function:
excel
Copy code
=CONCATENATE("0", TEXT(A1, "0"))
Simply enter the formula in the desired cell, replacing "A1" with the actual cell reference of the number you want to convert.
Additional Note for Google Sheets: Custom Number Format
In Google Sheets, you can also use custom number formatting to display leading zeros without changing the actual value in the cell. Select the cell, go to "Format" in the menu, choose "Number," and then select "Plain Text" or "Custom Number Format" to enter a custom format like 0000 for leading zeros.
#googlesheetstutorial
#msexcelfullcourse
#msexcel
Remember to adjust the cell references according to your specific case.
COMMUNICATE WITH HASAN ACADEMY
[email protected]
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650