Add zero in any number and mobile number এমএস এক্সেল ফুল কোর্স | MS Excel Full Course
If you want to add a zero in front of a number in Microsoft Excel, you can use the CONCATENATE function or the "&" operator to combine the zero and the number. Here are two methods to do so:
Method 1: Using the CONCATENATE function:
Open the Excel worksheet that contains the numbers that you want to add a zero to.
In a new cell, type the following formula: =CONCATENATE("0",A1), where A1 is the cell that contains the number you want to add a zero to.
Press Enter to see the result. The formula will return a string that combines the zero and the number in cell A1.
Method 2: Using the "&" operator:
Open the Excel worksheet that contains the numbers that you want to add a zero to.
In a new cell, type the following formula: ="0" & A1, where A1 is the cell that contains the number you want to add a zero to.
Press Enter to see the result. The formula will return a string that combines the zero and the number in cell A1.
Note: In both methods, the result will be a string, not a number. If you want to perform arithmetic operations with the resulting string, you'll need to convert it back to a number.
COMMUNICATE WITH HASAN ACADEMY
[email protected]
Facebook page
/ hasanacademybanglatutorial
Subscribe link : / @hasanacademy779
Facebook group link : / 282270382269650