Trick to add digits in a cell in Excel

CA Rishabh Pugalia (ExcelNext) , Last updated: 21 February 2017  
  Share

Now I will tell you how to add prefix 00 for a check number. For example, you have the data like below (before). Now the point is how you will format cells in excel so that total digit should look like six digit code. It is possible to add zeroes manually. But the zeroes will go away un

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 1999/-

Offer Price : INR 999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)
Join CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Students   Report

Other Articles  
Comment   Share
6 Likes   11916 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro

Trending Online Classes

view all classess

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category