How to Resize Photos in Batch?: Solution to Problem: Custom format number with compound expression possible?

Monday, September 26, 2016

Solution to Problem: Custom format number with compound expression possible?

Custom format number with compound expression possible?

I need to allow users to enter into a numeric field and then format the numbers with dashes. My problem is that one of the formats only applies to a range of numbers in the middle. For those above and below the range AND below the highest range, the leading
zero needs to show. How do I do that?
This is what I'm entering and what I'm trying to do:
Data entered     Desired output
0204811026       020-48-11-026
503182564       503-18-25-64
0604813057       060-48-13-057
1104821085       110-48-21-085

This format works for everything except the third example:
[<503000000]0##-##-##-###;[>999999999]###-##-##-###;###-##-##-##

What I really want to be able to do is this:
[between 503000000 and 503999999]###-##-##-##;[>999999999]###-##-##-###;0##-##-##-###

but I can't figure out how to do a between or [> 503000000 and < 503999999].

Any help would be greatly appreciated.

Jaime

Anwsers to the Problem Custom format number with compound expression possible?

Download Error Fixer for Free Now

In Excel 2007, select the cells where you want this formatting to be used.
Set your original number format for all of these cells (as far as I can see, 000-00-00-000 should do the job).
Make sure you notice which of those is the active cell, highlighted in white rather than in colour (I'll assume you select these top to bottom so let's say you select B2:B100 and B2 is the active cell)
Now go to the Home Ribbon > conditional formatting > new rule.

Choose the last option "use a formula to determine which cells to format".
In the formula box, type this condition:
=AND(B2>=503000000, B2<=503999999)
Click on the "Format" button and set the format you want for cells which match this condition.
In your case that means go to the "Number" tab, go to custom and put in the custom number format you need (###-##-##-## as far as I can see
from reading your question).
OK, OK to get out again.

As long as the cell reference you use is the cell in the selected range which was active, this will work.
Basically cell B2 uses it's own value for the test, B3 uses B3 etc, very similar to how formulas update when you drag them down to fill, except there's
no real way to "see" this in the condition, you just have to know and trust that it is working.

Hope this helps, and sorry for the delay in coming back (while Answers was in read-nly mode being upgraded I could not reply!)

Check if there are memory problems

Memory management issues can also cause a BSOD in Windows 7. Thankfully, Windows 7 has a Memory Management Diagnostic tool that detects and solves problems related to system memory.

Click on the Start button on the Taskbar.
Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
Click on Windows Memory Diagnostic Tool (in the search results).
Click on "Restart now and check for problems (Recommended)".
The system will restart, and you need to follow the instructions given on the screen.

Another Safe way to Repair the Problem: Custom format number with compound expression possible?:

How to Fix Custom format number with compound expression possible? with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system. Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

How to Resize Photos in Batch?