Working with excel one of the main problem we face how to custom format the cell. That means how to show 12 as 00012 or 123 as 00123.
There is also an issue how to only show month in different forms.
Another issue is how to pre-fix or suffix custom text with the number in the cell.
The file 'custom format cell' can be downloaded from
www.ncon.in/excel.htm ('custom format cell')
which demonstrates the use of Tricks where you can custom format the cell.
Excel has powerful function for custom formats only you need to learn and understand how to use it.
No comments:
Post a Comment