Recent Questions

متن مرتبط با «excel date format not working» در سایت Recent Questions نوشته شده است

[Updated] Free Mobile-Friendly Layout Wizard

  • نیلوبلاگ

    Updated: The Free Mobile-Friendly Layout Wizard has been updated. It will now place the meta charset tag before the title in the head section (so that it will be in the first 1 KB of your page even if you have a long title). In addition, if you select HTML5 as the output type, the shorter meta charset tag will be used....

    ادامه مطلب
  • [Updated] Feedback Form Wizard: improved PHP 8 (8.0, 8.1, etc) compatibility

  • نیلوبلاگ

    The script generated by the Feedback Form Wizard has been updated to improve compatibility with PHP 8 (eg, 8.0, 8.1, etc). Note: if you have generated your form and script after 1 January 2023, you already have this version (ver 3.2.0). ...

    ادامه مطلب
  • Running Docker on M1 Mac - docker: compose is not a docker

  • نیلوبلاگ

    When upgrading from an Intel mac to an Apple Silicone I noticed docker fails to run. I'm using Laravel Sail when Sail is installed or when a sail up command is attempted I get an error:  docker: 'compose' is not a docker command The reason for this is a docker-compose is now a plugin. Docker needs docker-compose to be installed. Use brew to install docker-compose brew install docker-compose Once installed sail will function normally without any extra setup. بخوانید...

    ادامه مطلب
  • [Updated] BlueGriffon Tutorial: Design a website using the open source BlueGriffon web editor

  • نیلوبلاگ

    The entire BlueGriffon Tutorial has been updated for the version 3 series of BlueGriffon. Those thinking of using it to create a website can find the complete series online....

    ادامه مطلب
  • What To Do If You Do Not Own Your Website's Domain Name

  • نیلوبلاگ

    What if someone else owns the domain on which your website sits? For example, as it was in the case of one of my visitors, someone may have bought the domain for you, and retained ownership of it. Or perhaps your website is on a free web host, or a blog host, and you are using the web address given to you by them. This article deals with how you can solve that problem (or potential problem)....

    ادامه مطلب
  • [Updated] Free Mobile-Friendly Layout Wizard: now creates 1, 2, 3 column websites

  • نیلوبلاگ

    For the sake of completeness (and also because a visitor requested it), the Layout Wizard has been updated to support one column websites as well. As a result, it can now create one, two and three column websites (depending on which you prefer). The generated web page is mobile-friendly and completely customizable. There are no advertisements, and nothing you enter into the Wizard is recorded anywhere. And it's free....

    ادامه مطلب
  • How to Create a Website (Updated)

  • نیلوبلاگ

    If you are thinking of designing a website, whether a business or hobby site, read How to Create a Website. The article has been updated with the latest developments on the Inteet. ...

    ادامه مطلب
  • [Updated] How to Add a CAPTCHA Test to Your Feedback Form Script: Reducing Spam in Your Contact Form

  • نیلوبلاگ

    The article on how to add a CAPTCHA to your contact form has been updated to include information on how you can use the newest CAPTCHA option (the one that potentially pays you for using them) of the Feedback Form Wizard. ...

    ادامه مطلب
  • [Updated] Free Feedback Form Wizard: new CAPTCHA option for reducing spam

  • نیلوبلاگ

    The Feedback Form Wizard has been updated to include an additional CAPTCHA option. This one is not only free, it apparently even pays you when your visitors solve the CAPTCHA challenges. For those wondering, CAPTCHAs are those "I am not a robot" or "I am human" checkboxes on forms, used to make sure that a human is at the helm, and not some spam robot....

    ادامه مطلب
  • Excel Vlookup find matching string

  • نیلوبلاگ

    I want to get with my ID the matching string, I am trying to accomplish that with a VLOOKUP =VLOOKUP(L2;Tree_Matchingnode!A:B;1;0) The Table that I am doing the Vlookup looks like this: +----------------+------------------+ | Parent_TREE_ID | Parent_TREE_NAME | +----------------+------------------+ | 1 | | | 2 | | | 3 | | +----------------+------------------+ The Matching tabel looks like this: +----...

    ادامه مطلب
  • Windows 10 Pro (UPGRADED FROM HOME) cannot join to domain only in Anniversary Update 1607

  • نیلوبلاگ

    I have a room full of machines that I have been upgrading from home to pro (Windows 10). All machines that are NOT anniversary update 1607 can be joined to a domain with no issues. All that are the anniversary update will allow me to join to the domain and it restarts and asks for the useame and password. Put in my credentials and it provides a generic "cannot log you in" error message. I've also noticed lusrmgr.msc is missing (Local users and groups) in all of these 1607 upgrades. The earlier b...

    ادامه مطلب
  • Major Chrome failure: All extensions say ERR_FILE_NOT_FOUND

  • نیلوبلاگ

    So Chrome freaked out one day and wouldn't load any pages. After completely uninstalling and reinstalling and reinstalling again using the dev channel and tuing off account sync and removing all history from the servers (ouch), I actually got it to work again as a browser but all my extensions are dead. They show the little puzzle piece (like in this question) and when I try to access the options or use them I get ERR_FILE_NOT_FOUND. I have tried uninstalling them all countless times, via right-...

    ادامه مطلب
  • How to get MS Word to use footnote citations instead of inline citations?

  • نیلوبلاگ

    I am preparing a sizable document in Microsoft Word 2013, and I want to use the MS Word functionality for references. Imagine I have a book that the bibliography, Chicago Style, looks like this: Fletch, Fletch F. 1985. *Important Quotes.* Los Angeles: Fake Publisher. I want to do a footnote citation automatically with MS word. It should look like this one that I entered manually: However, when I click "Insert Footnote" then "Insert Citation", it just sticks an inline-citation in the footnote...

    ادامه مطلب
  • VirtualBox VM not starting after upgrade

  • نیلوبلاگ

    Don't look for the drivers on inteet, /sbin/vboxconfig builds them. The problem was the old drivers were still present and preferred. So I removed the old drivers and ran /sbin/vboxconfig again, this time it worked.sudo mv /lib/modules/3.16.0-4-amd64/updates/dkms/vbox* /tmp(Moving to /tmp instead of rm just in case)The directory may vary, I found it in the first command in my question with lsmod then modinfo. Then sudo /sbin/vboxconfig and it should work The new drivers are in /lib/modules/3.16....

    ادامه مطلب
  • How to SUM a column based on range and another column being distinct?

  • نیلوبلاگ

    I have column 1 and it has dates. I have column 2 and it has inventory sold. The dates are duplicated from several systems - which means for a given date there are at least 7-10 numbers for inventory sold. We simply want to take the highest amount for a specific date and show the SUM of that column for inventory. Mean we are only adding 1 inventory amount per date. Let's block ads! بخوانید...

    ادامه مطلب
  • OpenVPN only works as long as System is not rebooted

  • نیلوبلاگ

    I hope this is the right place to ask this. My University lets students download a preconfigured executable of OpenVPN, where the settings are already branded in. Once you installed it, you just enter your credentials and you are connected. However, I noticed that it doesn't work anymore after the system is has been installed on is rebooted. If I install it, I get a successful connection with the VPN and can use it. If I restart my Laptop, it does not work anymore, but the Icons in the Tray stil...

    ادامه مطلب
  • Windows 10 claims that memory is full, when it really should not be

  • نیلوبلاگ

    I have a Windows 10 PC with 8GB of RAM that frequently generates "low memory" waings, even when barely any applications are open. Example: Can anyone explain what is going on, and what can be done to fix this? ...

    ادامه مطلب
  • Chrome gets stuck on "server DNS address could not be found" if I tried to access a domain while connecting

  • نیلوبلاگ

    This happens to me quite a lot, and I'd like to know if there's a way to prevent it or a better way to fix it than restarting my computer. The circumstances are very different to existing questions like “DNS server address couldn't be found” for some websites; it goes like this: I tu on my computer (Windows 8.1) and inteet router (which is either a 3G mobile router that I'm waking up from sleep, or a normal wireless router and modem that isn't on all the time because I'm in a country where there...

    ادامه مطلب
  • Adding refrenced cells in Excel 2013

  • نیلوبلاگ

    So I have been trying to add refrenced cells but each time I input the sum formula is get 0 as an answer. I did a search online and realised that I'm to use the indirect formula but I just cannot make head or tail of it. At best I am able to retrieve one number but my intention is not retrieval alone but adding the numbers in the refrenced cells. Any help will be greatly appreciated Oops I cannot post pictures at the moment but I hope the description of my headache will be understood from the th...

    ادامه مطلب
  • warning /dev/root does not exist

  • نیلوبلاگ

    Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top ...

    ادامه مطلب