Intial Zero to MS-Excel Cell.
Hello Friends,
This is Tularam Chaudhary.
Today I show you how to put Initial Zero in an MS-Excel cell without pressing apostrophe comma. Because I think everyone put Initial Zero after apostrophe comma and then other number. But I show you how to put Initial Zero in a cell without apostrophe comma.
First
You can open or create an excel file and put the given numbers without zero.
Go to the next column press '=' (equal to) sign, after that press '0' (Zero) and '&' (and sign) and that column in which numbers are feed previously and press Enter. After that hide the column in which numbers are feed previously.
At last copy the formula and paste in every cell in which you want Initial Zero.
To know more about the formula press the given link and watch the given video.
https://youtu.be/9VGX5tE3-Lc
Thank you for watching my post and video.
This is Tularam Chaudhary.
Today I show you how to put Initial Zero in an MS-Excel cell without pressing apostrophe comma. Because I think everyone put Initial Zero after apostrophe comma and then other number. But I show you how to put Initial Zero in a cell without apostrophe comma.
First
You can open or create an excel file and put the given numbers without zero.
Go to the next column press '=' (equal to) sign, after that press '0' (Zero) and '&' (and sign) and that column in which numbers are feed previously and press Enter. After that hide the column in which numbers are feed previously.
At last copy the formula and paste in every cell in which you want Initial Zero.
To know more about the formula press the given link and watch the given video.
https://youtu.be/9VGX5tE3-Lc
Thank you for watching my post and video.
Comments
Post a Comment