Recent Questions

متن مرتبط با «excel date format» در سایت 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). ...

    ادامه مطلب
  • [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....

    ادامه مطلب
  • [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...

    ادامه مطلب
  • 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...

    ادامه مطلب
  • Windows 10 asks for updates ignoring update GPO

  • نیلوبلاگ

    Why Windows 10 asks user to update their computer also if they are under domain with GPO set to automatically update? This did not happen with Win 7 and I did not change any GPO about updates. ...

    ادامه مطلب
  • Can I restore file system and without formatting the hard drive

  • نیلوبلاگ

    I have a 2TB hard disk and the file system is corrupted. I am not able to access the data. How can I access the data or restore the file system so that I can use it normally? ...

    ادامه مطلب
  • Windows Update Stalled on Windows 7

  • نیلوبلاگ

    Windows Update stalls on Windows 7 SP1 is installed Will update Security Essentials definitionsa scan found no problemscomputer has never had a virus that I know of The hard drive had not been used for a couple yearsIt did install 4 old update that had been downloaded but not yet installedIt is a sister to an identical computer that had a failed mother boardThe hard drive failed so I just took the hard drive from the bad mother boardBut that does not seem to be a problem - it Activated and every...

    ادامه مطلب
  • Moving data from cells on one excel spreadsheet to another based on a true condition

  • نیلوبلاگ

    I am using a spreadsheet that contains constant data; I would like to be able to populate the cells on another spreadsheet with this data when a condition is true. I.e. The target spreadsheet is used to prepare estimates. When the user selects a predefined price quote from the spreadsheet containing the constant data, I would like to move this data to the Estimate Spreadsheet. Any assistance would be greatly appreciated. Jamie Let's block ads! بخوانید...

    ادامه مطلب
  • Windows 10 Anniversary Update error 0xc1900101-0x20017

  • نیلوبلاگ

    When I try to update to the Anniversary Update it gives me after first reboot 0xc1900101-0x20017 before the copying files thing. Can anyone help me fix this issue? I can't afford to perform a clean install, too much to back up I have a Dell Inspiron 5537 15R with WIndows 10 Home 10586.545. Let's block ads! بخوانید...

    ادامه مطلب
  • Rearrange Rows in Microsoft Excel to Columns in new sheet

  • نیلوبلاگ

    I have a list of data that I need to rearrange in a specific way in the next sheet. I want to make the data to automatically be inputted to the next sheet as below as the total data is actually a lot and it takes time to do this by transposing and copy pasting to the correct order. Is it possible to make the data be arranged as such automatically by functions/macros? Let's block ads! بخوانید...

    ادامه مطلب
  • How do I get my previous request of information off of "on hold"? [migrated]

  • نیلوبلاگ

    I guess i worded my first question on my profile wrong or was unclear about it, but I recently edited it and added comments to verify. Still on hold, can anyone inform me please. ...

    ادامه مطلب
  • Excel, create a list of people that meet targets

  • نیلوبلاگ

    Can someone please help me generate a list of people that hit their targets for different days, when they hit both of their targets a '2' will show in either the Y column or Z respective if they are early or late shift. i would like everyone that gets a 2 on their shift to be listed. Here is the Data Here is the outcome I am attempting Let's block ads! بخوانید...

    ادامه مطلب
  • Windows 10 slow boot and shutdown after anniversary update

  • نیلوبلاگ

    After installing the Windows 10 anniversary update, my computer boots very slow. The first part of booting (bios, loading Windows) is as fast as it used to be, but after logging in I'm stuck on a black screen with just my cursor for over a minute before it seems to continue with the login. I made a video to explain what I mean. Also, when I shutdown, Windows says that Spotify is blocking the shutdown - Which is strange because why would Spotify do this? It will stay on this screen for about a mi...

    ادامه مطلب
  • Excel 2013 Open All Recovered Files

  • نیلوبلاگ

    I recently opened ~70+ Excel files all at one time (it was a massive data dump from a database which I was going to be locked out of in about 30 minutes, so I wanted to grab everything I could conceivably need). Unsurprisingly, my Excel crashed from the load. Upon restarting Excel, the Document Recovery pane opened and showed me all of the files. Is there a way to automatically have all the files in the Document Recovery Pane open up? I don't want to have to manually go through and open up 70+ d...

    ادامه مطلب