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:
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.

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.

  1. Click on the Start button on the Taskbar.
  2. Type "Windows Memory Diagnostic Tool" or "Memory" (without quotes) in the Search box or,
  3. Click on Windows Memory Diagnostic Tool (in the search results).
  4. Click on "Restart now and check for problems (Recommended)".
  5. 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.

Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 -,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v. driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: custom bookmark icons don't display in internet explorer 8 [Anwsered],Daily restore point not being created - Win 7 [Anwsered],Troubleshoot:Data involves different skills in a 15min interval. how can i create a template that would show 30-min interval?,How Can You Fix - Dead Pages and vanishing cursor?,Fast Solution to Problem: Dell Inspiron 1545 laptop...32 bit...Windows 7...often gets full page of horizontal streaks and problems in power-off & on.

No comments:

Post a Comment