Hello all,
Whenever you export a numeric colum with leading zeros, excel trims/removes the leading zeros. I was running into an issue where I needed the leading zeros to be as is since they were meaningful(like in the case of zip codes which start with a zero) After a lot of searching I found the article
How to add leading zeros in Excel on eHow.com
which explains process in very simple terms. Here is the link to the article
http://www.ehow.com/how_4703826_add-leading-zeros-excel.html
Happy Excelling
This blog is a journal of the tips and tricks I use on a routine basis.
Tuesday, July 27, 2010
Wednesday, July 7, 2010
My journey to PMP Land
Hello All,
One beautiful day, I had an epiphany that I should get my PMP certification. I have been working on projects all the time, I follow the PMP methodology, the one thing I did not have was the certification. So now I am in preparing to get certified. I am going to document my process and I hope this will be helpful for others who intend to get certified.
Here is what I have done so far.
I completed the application form on PMI.org and became a member of PMI.
I have downloaded the PMBOK 4th edition and read it once.
I have purchased Andy Crowe's PMP certification Book and am in the process of reading the book.
Now I have to prepare a plan to study and pass the exam.
Shri
One beautiful day, I had an epiphany that I should get my PMP certification. I have been working on projects all the time, I follow the PMP methodology, the one thing I did not have was the certification. So now I am in preparing to get certified. I am going to document my process and I hope this will be helpful for others who intend to get certified.
Here is what I have done so far.
I completed the application form on PMI.org and became a member of PMI.
I have downloaded the PMBOK 4th edition and read it once.
I have purchased Andy Crowe's PMP certification Book and am in the process of reading the book.
Now I have to prepare a plan to study and pass the exam.
Shri
Subscribe to:
Posts (Atom)