Tag Archives: Format

Display single letter Day of week in Excel

Is it achievable?  Not by formatting but formula. Advertisements

Rate this:

Posted in Format, Formula | Tagged , , , | Leave a comment

Reference to a cell without source number format

You probably knew it… when we make a direct reference to a cell, i.e. input =A1 in A2, the cell A2 will then follow the number format of A1.  Put it in other words, if the number format of A1 is … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Input fraction number in Excel

This title sounds a bit silly,  but I do believe many users must have experienced frustration when they tried to input a fraction number as simple as 1/2 in Excel. When we input something like x/y, Excel assumes that we are … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Show number in thousand (k) or in million (M) by using custom format

The custom format to show number in thousand or in million is simple: #,##0,“k” #,##0,,“M” The “k” or “M” is optional, depend on whether you want to show it in the header or in the figure itself. The trick is … Continue reading

Rate this:

Posted in Excel Basic, Excel Tips | Tagged | 3 Comments

Date Formats – A trick to format date with “st”, “nd”, “rd”, “th”

Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂

Rate this:

Posted in Excel Tips, Formula | Tagged , , , | 4 Comments

Text Alignment – Fill

We talked about examples of using “Text Alignment – Indent” in the previous post.  In the coming posts, let’s talk about the rest of the less commonly-used text alignments.  Actually, I find it a bit challenging to cite real-life examples … Continue reading

Rate this:

Posted in Format | Tagged , , | 1 Comment

Format part of a formula result… A workaround (non-VBA) solution

How to format part of a formula result? In a normal text string, we may format part of the text to highlight a specific information.  For example, if we input the text string “Today is Thursday, 01/05/2014” in A1, we … Continue reading

Rate this:

Posted in Excel Tips, Format | Tagged , | 6 Comments

Excel Basic – Looks can be deceiving

Once upon a time, I was questioned about the accuracy of calculation in Excel just because one saw a formula “3% x 100” (A1*B1) yielding a result of 2.5 (C1).  WHY???? As a basic but important rule, DO NOT trust … Continue reading

Rate this:

Posted in Excel Basic | Tagged | 1 Comment