Displaying 1 - 10 of 49429 in 4943 pages
CA. Rishabh Pugalia (ExcelNext Wrote on 20 June 2013
@Atul - Very good suggestion. Your method is simpler and most apt for printing/display purposes. However, for data migration and Lookups, the data must have actual Zeroes (not Custom Format). So depending upon the requirement, users may opt for any one fo the 2 approaches.
Akshay Jain Wrote on 19 June 2013
seriously its a very motivating article for a student who is about to do CA
Atul Gandhi Wrote on 19 June 2013
There is another simple way to achieve desired result.
Keep the pointer where the zeros to be prefixed.
Go to Format cell, Enter, Select " Customs " Enter, Select option ( 0 ) with as many charcter as required.
johnson anthonidas Wrote on 19 June 2013
Dear Ashish Barthwal
I m waiting for article on MAT which has Computations also
Kindly provide the article ASAP
it will be a great help
Rajat Poddar Wrote on 19 June 2013
u can same find it under my contributions... i have uploaded the same file in PDF format also...
Click here to report abuse or copyright issues