Custom Format to Catch Numbers Appearing as Text

When raw data (in text *txt or csv format) is imported to excel, the conversion can sometimes have an unintended side-effect - the numbers come out as text after the process. The only choice left is to identify the columns that contain numbers masquerading as text and then to use the text to column option on each of the columns one-by-one. If the number of columns is large, eyeballing the data can be a ...

Continue Reading

Custom Format to Catch Numbers Appearing as Text

Using Custom Format to Color Chart Axis and Chart Labels

Posted on 30 September 2009

Using Custom Format to Color Chart Axis and Chart Labels
Custom Format can be used to format numbers, text, dates and time. The technique can be extended to charts as well where the custom format feature can be used to color the chart axis and chart labels. In this example, let's say we wanted to show the sales numbers for a particular duration as a chart. We would, in addition, like to have some kind of separation between what is considered below, average and above average performance. Custom format ...
Continue Reading

Comments     

Conditional Formatting and Custom Format – Use More than Three Colors

Posted on 16 September 2009

Conditional Formatting and Custom Format  - Use More than Three Colors
Conditional formatting (in pre Excel 2007 versions) had a limitation of only allowing for upto three conditions for formatting cells. A quick way to include more than three conditions when using conditional formatting is to use the custom format feature in tandem with it. Conditional formatting can be used to specify the first three conditions and then upto three additional conditions can be specified using custom format - giving us 6 different colors to work with. ...
Continue Reading

Comments (1)

Custom Format to Left Align Text Symbol and Right Align Numbers

Posted on 13 September 2009

Custom Format to Left Align Text Symbol and Right Align Numbers
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 (3)

Custom Format in Excel – How to Format Date and Time

Posted on 07 September 2009

Custom Format in Excel - How to Format Date and Time
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

Custom Format in Excel - How to Format Numbers and Text
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 (19)

Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel


ARCHIVES