Very neat trick, but not sure I see the value in using it.When you see 1/1/1900 in a Date cell that usually means an invalid value has been entered.If your doing a calculation, and the result will not be a Date, then perhaps the cell should not be formatted as a Date cell?Here is another way of doinRead more
Very neat trick, but not sure I see the value in using it.
When you see 1/1/1900 in a Date cell that usually means an invalid value has been entered. If your doing a calculation, and the result will not be a Date, then perhaps the cell should not be formatted as a Date cell?
Here is another way of doing the same thing, but this will display a Zero in the formula bar not 01/00/1900:
Try running the check disk utility that's built into Windows, by going to the command prompt (Click on Start, go to Run, and then type in Cmd.exe) and type in the following without the quotes " Chkdsk" and press enter, this will scan your drive to make sure everything is in working order. Here's theRead more
Try running the check disk utility that’s built into Windows, by going to the command prompt (Click on Start, go to Run, and then type in Cmd.exe) and type in the following without the quotes ” Chkdsk” and press enter, this will scan your drive to make sure everything is in working order. Here’s the link to the Microsoft page if you need help: http://support.microsoft.com/kb/315…
It could also be a piece of hardware that’s malfunctioning, as I’ve noticed you’ve said you’ve reformated, but the problem is still there.
You could try downloading and install the newest drivers for the motherboard and keyboard, then delete the keyboard in device manager, then restart the machine. Windows will reinstall the keyboard with the newer driver at boot up when it finds new hardware. IF this does not work, it is most likely hRead more
You could try downloading and install the newest drivers for the motherboard and keyboard, then delete the keyboard in device manager, then restart the machine. Windows will reinstall the keyboard with the newer driver at boot up when it finds new hardware. IF this does not work, it is most likely hardware related as above. If under warranty then take it in for service, if not then you MAY want to open and check for obvious problems, but you probably should just take it in anyway.
You have to be a little bit crazy to keep you from going insane.
When you UN-Install use this FIX-IT:https://support.microsoft.com/en-us...It should remove any registry keys that may be left floating around by theregular uninstall program.You might also want to run something like CCleaner and remove any strayregistry files it finds.Found this page, but it seems tRead more
It should remove any registry keys that may be left floating around by the regular uninstall program. You might also want to run something like CCleaner and remove any stray registry files it finds.
Found this page, but it seems to apply only to the WPFT 632 part of the error message. It also is a registry hack.
enter the bios, set vram size for the integrated graphics to 2048MB or 2GB, this is the maximum for integrated Vega graphics on AMD CPU's like the Ryzen 5 2500u.Tho some manufacturers lock this ability for normal users, for "safety reasons", basically they don't want unknowing customers to alter theRead more
enter the bios, set vram size for the integrated graphics to 2048MB or 2GB, this is the maximum for integrated Vega graphics on AMD CPU’s like the Ryzen 5 2500u.
Tho some manufacturers lock this ability for normal users, for “safety reasons”, basically they don’t want unknowing customers to alter their products setup, because it can damage the machine. like explained here: https://h30434.www3.hp.com/t5/Noteb…
btw there shouldn’t be much of a difference, because if the vega grahpics(iGPU) runs out of Vram (integrated GPU vram is actually system RAM), it will tap into the system RAM anyways.
the only benefit you could see, would be games or other apps, checking your hardware setup to see if there is enough dedicated Vram available. So the app will not check for the not yet allocated system RAM, which the onboard Vega GPU can also use as Vram.
Hope this makes sense, if it doesn’t feel free to ask away.
notes:
GPU=Graphics processing Unit on-board graphics=same as GPU iGPU=integrated GPU ^ (means the same for you as the 2 above) VRAM=Memory dedicated to the GPU RAM=system memory YOUR GPU=AMD RX Vega 8 (Ryzen iGPU) YOUR CPU=AMD Ryzen 5 2500U default iGPU(vega 8 grpahics) vram=128MB or 256MB max iGPU vram=2048MB or 2GB for short
It should be on a sticker on the underside of the laptop if it was pre-installed at the factory. If the sticker fell off, was removed, or Win7 wasn't factory installed, go here:http://pcsupport.about.com/od/produ...
It should be on a sticker on the underside of the laptop if it was pre-installed at the factory. If the sticker fell off, was removed, or Win7 wasn’t factory installed, go here: http://pcsupport.about.com/od/produ…
Try this:=IF(ISNA(VLOOKUP($A2,'CoP Expiry'!$A$2:$B$6000,2,0)),"",IF(VLOOKUP($A2,'CoP Expiry'!$A$2:$B$6000,2,0)=0,"",VLOOKUP($A2,'CoP Expiry'!$A$2:$B$6000,2,0)))Excel didn't like it if the VLOOKUP returned #N/A within the OR. The #N/A error took precedence over the OR.Just a tip:If you had used the FRead more
The same requirements for Windows 2000 apply to Windows XP. Your Update Agent is probably outdated:https://computing.net/answers/wi...I should also point out that the updated root certificates are also required for Windows Update to run under Windows 2000. Available here: http://download.windowsupdaRead more
The same requirements for Windows 2000 apply to Windows XP. Your Update Agent is probably outdated:
What make\model is your TV?is it a smart TV? through habit I always put all my remote controls away and use an app on my phone to navigate through the TV. If you have a smart tv and it is connected to your wifi, and you have a smart phone, perhaps you can download an appropriate app?
What make\model is your TV?
is it a smart TV? through habit I always put all my remote controls away and use an app on my phone to navigate through the TV. If you have a smart tv and it is connected to your wifi, and you have a smart phone, perhaps you can download an appropriate app?
How To avoid 1/1/1900 instead show blanks in dates in Excel.
Very neat trick, but not sure I see the value in using it.When you see 1/1/1900 in a Date cell that usually means an invalid value has been entered.If your doing a calculation, and the result will not be a Date, then perhaps the cell should not be formatted as a Date cell?Here is another way of doinRead more
When you see 1/1/1900 in a Date cell that usually means an invalid value has been entered.
If your doing a calculation, and the result will not be a Date, then perhaps the cell should not be formatted as a Date cell?
Here is another way of doing the same thing, but this will display a Zero in the formula bar not 01/00/1900:
Custom Format: [=0]””;General
MIKE
http://www.skeptic.com/
Solved I/O error status of 0xc000000e.
Try running the check disk utility that's built into Windows, by going to the command prompt (Click on Start, go to Run, and then type in Cmd.exe) and type in the following without the quotes " Chkdsk" and press enter, this will scan your drive to make sure everything is in working order. Here's theRead more
It could also be a piece of hardware that’s malfunctioning, as I’ve noticed you’ve said you’ve reformated, but the problem is still there.
Solved How do we disable Alt + F4 shortcut. is one of the worst one
Disable alt+F4http://www.sevenforums.com/general-...
http://www.sevenforums.com/general-…
Solved why are half of my keys not working?
You could try downloading and install the newest drivers for the motherboard and keyboard, then delete the keyboard in device manager, then restart the machine. Windows will reinstall the keyboard with the newer driver at boot up when it finds new hardware. IF this does not work, it is most likely hRead more
You have to be a little bit crazy to keep you from going insane.
Solved Word 2016 cannot start the Converter RECOVER32
When you UN-Install use this FIX-IT:https://support.microsoft.com/en-us...It should remove any registry keys that may be left floating around by theregular uninstall program.You might also want to run something like CCleaner and remove any strayregistry files it finds.Found this page, but it seems tRead more
https://support.microsoft.com/en-us…
It should remove any registry keys that may be left floating around by the
regular uninstall program.
You might also want to run something like CCleaner and remove any stray
registry files it finds.
Found this page, but it seems to apply only to the WPFT 632 part of the
error message. It also is a registry hack.
http://www.yodot.com/doc-repair/wor…
They do offer a software solution, but it appears to be for recovering a
corrupt document. Proceed with caution, as I have never used this site.
MIKE
http://www.skeptic.com/
increase vram without bios
enter the bios, set vram size for the integrated graphics to 2048MB or 2GB, this is the maximum for integrated Vega graphics on AMD CPU's like the Ryzen 5 2500u.Tho some manufacturers lock this ability for normal users, for "safety reasons", basically they don't want unknowing customers to alter theRead more
Tho some manufacturers lock this ability for normal users, for “safety reasons”, basically they don’t want unknowing customers to alter their products setup, because it can damage the machine.
like explained here:
https://h30434.www3.hp.com/t5/Noteb…
But Vram capacity for vega might be unlocked 🙂
here is an example video:
https://www.youtube.com/watch?v=506…
btw there shouldn’t be much of a difference, because if the vega grahpics(iGPU) runs out of Vram (integrated GPU vram is actually system RAM), it will tap into the system RAM anyways.
the only benefit you could see, would be games or other apps, checking your hardware setup to see if there is enough dedicated Vram available. So the app will not check for the not yet allocated system RAM, which the onboard Vega GPU can also use as Vram.
Hope this makes sense, if it doesn’t feel free to ask away.
notes:
GPU=Graphics processing Unit
on-board graphics=same as GPU
iGPU=integrated GPU ^ (means the same for you as the 2 above)
VRAM=Memory dedicated to the GPU
RAM=system memory
YOUR GPU=AMD RX Vega 8 (Ryzen iGPU)
YOUR CPU=AMD Ryzen 5 2500U
default iGPU(vega 8 grpahics) vram=128MB or 256MB
max iGPU vram=2048MB or 2GB for short
i5-6600K[delid]test31404562.7GHz/4.4GHz cache/test6513316.395v LLC=6 | 2x4GB Crucial-DDR4-2400CL17test65133164-15-15-28 1T 3000MHztest6513316.4v | MSI Armor RX 570 4GBtest6513316410Mhz coretest6513316.2v/1920MHz
message edited by hidde663
How To Find the product key on an acer
It should be on a sticker on the underside of the laptop if it was pre-installed at the factory. If the sticker fell off, was removed, or Win7 wasn't factory installed, go here:http://pcsupport.about.com/od/produ...
http://pcsupport.about.com/od/produ…
Solved VLOOKUP Returns 00/01/1900 Instead Of Blank
Try this:=IF(ISNA(VLOOKUP($A2,'CoP Expiry'!$A$2:$B$6000,2,0)),"",IF(VLOOKUP($A2,'CoP Expiry'!$A$2:$B$6000,2,0)=0,"",VLOOKUP($A2,'CoP Expiry'!$A$2:$B$6000,2,0)))Excel didn't like it if the VLOOKUP returned #N/A within the OR. The #N/A error took precedence over the OR.Just a tip:If you had used the FRead more
=IF(ISNA(VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,0)),””,IF(VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,0)=0,””,VLOOKUP($A2,’CoP Expiry’!$A$2:$B$6000,2,0)))
Excel didn’t like it if the VLOOKUP returned #N/A within the OR. The #N/A error took precedence over the OR.
Just a tip:
If you had used the Formula Evaluator feature you would have seen that.
How To Post Data or Code —> Click Here Before Posting Data or VBA Code
message edited by DerbyDad03
Solved Error code 0x80244019 when doing window XP update
The same requirements for Windows 2000 apply to Windows XP. Your Update Agent is probably outdated:https://computing.net/answers/wi...I should also point out that the updated root certificates are also required for Windows Update to run under Windows 2000. Available here: http://download.windowsupdaRead more
https://computing.net/answers/wi…
I should also point out that the updated root certificates are also required for Windows Update to run under Windows 2000. Available here: http://download.windowsupdate.com/msdownload/update/v3-19990518/cabpool/rootsupd_a153023b66d29034420aa227ccc2164cff75229e.exe (also can Google for rootsupd_a153023b66d29034420aa227ccc2164cff75229e.exe if the link ever goes down.)
Also update your browser to Internet Explorer 8 for the best results. Alternate
message edited by sdfox 7
Solved tv remote lost, how to access usb without it?
What make\model is your TV?is it a smart TV? through habit I always put all my remote controls away and use an app on my phone to navigate through the TV. If you have a smart tv and it is connected to your wifi, and you have a smart phone, perhaps you can download an appropriate app?
is it a smart TV? through habit I always put all my remote controls away and use an app on my phone to navigate through the TV. If you have a smart tv and it is connected to your wifi, and you have a smart phone, perhaps you can download an appropriate app?