Custom Format to Left Align Text Symbol and Right Align Numbers

Posted on 13 September 2009

In Custom Format Numbers and Text we discussed using the custom format feature on numbers and text. Here is a neat little trick using which we can format a cell to make the text symbol align left and the numbers present in the cell right. Hold your breath..here comes... "Custom Text Symbol"* General where: Custom Text Symbol is the customized symbol that you would like to appear against each number. So if ... Continue Reading

Comments     

Custom Format in Excel - How to Format Date and Time

Posted on 07 September 2009

In custom format in Excel we discussed using the custom format feature to format text and numbers. In this article, we format date and time values and see how we can make them appear more meaningful. If you haven't had a chance to read through the first part where we talked about basics of the custom format feature, it is highly recommended that you do so before coming back and finishing this one off. Before we begin, again please bear ... Continue Reading

Comments (2)

Custom Format in Excel - How to Format Numbers and Text

Posted on 27 August 2009

The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format. Before we get into the details, it is important to remember that when you format a cell using this feature, it does not change the value present in the cell. The only change is of how the value appears to the user on the screen. A custom format can be applied to a particular cell ... Continue Reading

Comments (10)

Excel Color Palette and Color Index change using VBA

Posted on 20 August 2009

Excel Color Palette has an index of 56 colors which can be modified using VBA. Each color in the palette is associated with a unique value in the index that can be changed programatically. At times it is useful to know the relative positioning of the various colors within this index as well as how various versions of Excel treat colors. This is the first in the series of articles that will expore this further. How to generate Excel Color Index ... Continue Reading

Comments (5)

Excel Slow to Respond - Avoiding Mistakes that Make Excel Slow Down to a Crawl

Posted on 06 August 2009

Everyone hates it when excel becomes slow to respond. So here are some tips to avoid doing things that can slow down excel. Excel 2007 and later versions sport a much bigger grid which tends to amplify poor spreadsheet design. An Excel spreadsheet that seemed a bit slow in Excel 2000 would likely get bogged down to a crawl in Excel 2007 if you, like me, are using the same hardware. The key to understanding what makes excel slow lies ... Continue Reading

Comments     

How to write a macro in Excel

Posted on 29 July 2009

How to write a macro in Excel? Here are a few quick tips: Excel Macro - How to Record Excel Macro - How to Edit Excel Macro - Improving speed of code Excel Macro - Examples Recording a macro in Excel How to record a macro in Excel 2007 and Excel 2010 In Excel 2007 (and Excel 2010), the "Record Marco" menu option is under the "View" ribbon. Click on the "Macros" button towards at ... Continue Reading

Comments