Dedirahman Sianturi

I have some simple trick in excel, in this sample I use Ms.Excel 2003. I write this article just to share my experience when I have simple problem in excel. I will separate this trick be 2 part.The first part is “Adding 0 number before another number” and the second part is “Adding millisecond sign in excel”. Alright I try to describes one by one.

The first trick “Adding 0 (Zero) number before another number “

As the sample I will try to write a number of number in the excel like the following picture

The next step is block rows A and B, right click there and then select Format Cells…

In the Number tab choose Custom Category, type “00000″# in Type text box.And then click OK

As the final result is like this

The second trick “Adding millisecond sign in excel”

If you confuse to add millisecond sign for time format in excel you can use this trick as the solution. First step for example you type the following text in excel

And the result is like this

You must be disappointed with this result because your desirability for time format until millysecondsign failed.

For the solution you can blok cell A and the right click there. In the Number tab, Custom category you can type hh:mm:ss.00 in the Type text box. This format will changes your cell format.

And the final result is this following picture

I hope this simple tips can help the readers. Thank’s

• Previous Entry: Define Field In Virtual Table Using SQL Server 2005
• Next Entry: Get this day and month in Indonesia Fomat with Excel