- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Advanced vlookup - wildcard characters "?" and "*"
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Advanced vlookup - Text vs. Number
- 2D SUMIF with two variables – one on column and one on row
- Copy data from strictly-protected sheet
- Show number in thousand (k) or in million (M) by using custom format
- Convert an 8-digit number into Excel-recognizable Date
Tag Archives: Format
Is it achievable? Not by formatting but formula. Advertisements
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
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
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
Well, there is no such custom format for date in Excel… However it can be achieved indirectly, with helper cell 🙂
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
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