Tag Archives: MOD

#,##0, k or #,##0.0, k ? Why not both?

Posted on December 16, 2017 by MF

Conditional Custom Formatting in #Excel Got the following question: This gives me £28.8 K (if 28800 is input) and £28.0 K if 28000 is input. I was rather hoping that if there was no decimal after the thousand, ie £28 … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

Allow time input at 15-min intervals only – Data Validation

Posted on August 16, 2014 by MF

How to limit user to input time at 15-min intervals, i.e. 00:15, 00:30, 00:45, 01:00, etc.? We talked about how to limit user to input Time in the previous post.  Let’s go one step further with Custom Data Validation, where you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Time Conversion – How to convert 24hr input as 4-digit number into TIME in Excel?

Posted on January 25, 2014 by MF

How to convert something like 1200 into 12:00? For easy sake of input, we often input 24-hr time as four digit number like 930 for 9:30, 1815 for 18:15 etc.  However, if time is input in this way in Excel, … Continue reading →

Rate this:

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