Explore Microsoft products and services for your home or business. Shop Surface, Microsoft , Xbox, Windows, Azure, and more. Find downloads and get support. Premium Office apps, extra cloud storage, advanced security, and more—all in one convenient subscription Get Microsoft Teams for free. Online meetings, chat, and shared cloud. Microsoft Corporation is an American multinational technology corporation which produces computer software, consumer electronics, personal computers, and related services headquarted at the Microsoft Redmond campus located in Redmond, Washington, United best-known software products are the Microsoft Windows line of operating systems, the Microsoft . Universal Serial Bus (USB) is an industry standard that establishes specifications for cables, connectors and protocols for connection, communication and power supply (interfacing) between computers, peripherals and other computers. A broad variety of USB hardware exists, including 14 different connector types, of which USB-C is the most recent.. First released in , the .
 
 

Office home and business install with product key (no – Microsoft Community – Need more help?

The working group has published three versions of audio device specifications: [56] [57] Audio 1. UAC 3. UAC 2. UAC 1. USB provides three isochronous fixed-bandwidth synchronization types, [67] all of which are used by audio devices: [68]. The connectors the USB committee specifies support a number of USB’s underlying goals, and reflect lessons learned from the many connectors the computer industry has used.

The female connector mounted on the host or device is called the receptacle , and the male connector attached to the cable is called the plug. By design, it is difficult to insert a USB plug into its receptacle incorrectly. The USB specification requires that the cable plug and receptacle be marked so the user can recognize the proper orientation. USB cables and small USB devices are held in place by the gripping force from the receptacle, with no screws, clips, or thumb-turns as some connectors use.

The different A and B plugs prevent accidentally connecting two power sources. USB connector types multiplied as the specification progressed. The connectors were different so that users could not connect one computer receptacle to another. The data pins in the standard plugs are recessed compared to the power pins, so that the device can power up before establishing a data connection.

Some devices operate in different modes depending on whether the data connection is made. Charging docks supply power and do not include a host device or data pins, allowing any capable USB device to charge or operate from a standard USB cable. Charging cables provide power connections, but not data. In a charge-only cable, the data wires are shorted at the device end, otherwise the device may reject the charger as unsuitable.

The USB 1. A bridge cable is a special cable with a chip and active electronics in the middle of the cable. The chip in the middle of the cable acts as a peripheral to both computers, and allows for peer-to-peer communication between the computers. Popularized by Microsoft as Windows Easy Transfer , the Microsoft utility used a special USB bridge cable to transfer personal files and settings from a computer running an earlier version of Windows to a computer running a newer version.

In the context of the use of Windows Easy Transfer software, the bridge cable can sometimes be referenced as Easy Transfer cable. Despite USB 3. These are not meant for data transfer but are aimed at diagnostic uses. Under the most recent specifications, USB supports most scenarios connecting systems directly with a Type-C cable. For the capability to work, however, connected systems must support role-switching.

Dual-role capabilities requires there be two controllers within the system, as well as a role controller. While this can be expected in a mobile platform such as a tablet or a phone, desktop PCs and laptops often will not support dual roles.

Low-power devices may draw at most 1 unit load, and all devices must act as low-power devices when starting out as unconfigured. High-power devices such as a typical 2. In addition to standard USB, there is a proprietary high-powered system known as PoweredUSB , developed in the s, and mainly used in point-of-sale terminals such as cash registers. A USB connection is always between a host or hub at the A connector end, and a device or hub’s “upstream” port at the other end.

During USB communication, data is transmitted as packets. Initially, all packets are sent from the host via the root hub, and possibly more hubs, to devices.

Some of those packets direct a device to send some packets in reply. At first, USB was considered a complement to IEEE FireWire technology, which was designed as a high-bandwidth serial bus that efficiently interconnects peripherals such as disk drives, audio interfaces, and video equipment.

In the initial design, USB operated at a far lower data rate and used less sophisticated hardware. It was suitable for small peripherals such as keyboards and pointing devices. These and other differences reflect the differing design goals of the two buses: USB was designed for simplicity and low cost, while FireWire was designed for high performance, particularly in time-sensitive applications such as audio and video.

The chipset and drivers used to implement USB and FireWire have a crucial impact on how much of the bandwidth prescribed by the specification is achieved in the real world, along with compatibility with peripherals. The IEEE They operate at 48 V DC and can supply more power up to This has made PoE popular for VoIP telephones, security cameras , wireless access points , and other networked devices within buildings.

Ethernet standards require electrical isolation between the networked device computer, phone, etc. This gives Ethernet a significant safety advantage over USB with peripherals such as cable and DSL modems connected to external wiring that can assume hazardous voltages under certain fault conditions.

USB is competitive for low-cost and physically adjacent devices. However, Power over Ethernet and the MIDI plug standard have an advantage in high-end devices that may have long cables.

USB can cause ground loop problems between equipment, because it connects ground references on both transceivers. This is an increasing disadvantage compared to USB. Even though USB 3. Thunderbolt 3 uses the USB-C connector. Thunderbolt 3 controllers can incorporate a USB 3. DisplayPort Alt Mode 2. DisplayPort 2.

After the specification was made royalty-free and custodianship of the Thunderbolt protocol was transferred from Intel to the USB Implementers Forum, Thunderbolt 3 has been effectively implemented in the USB4 specification—with compatibility with Thunderbolt 3 optional but encouraged for USB4 products.

Various protocol converters are available that convert USB data signals to and from other communications standards.

From Wikipedia, the free encyclopedia. Standard for computer data connections. This article is about the computer bus standard. For other uses, see USB disambiguation. Main article: USB 3. Main article: USB4. See also: Picture Transfer Protocol. Main article: USB human interface device class.

Main article: USB adapter. Electronics portal. May Archived from the original PDF on 13 March Retrieved 12 March Boston Globe Online. Archived from the original on 6 April Retrieved 12 December Retrieved 4 March Ziff Davis. Retrieved 17 February Retrieved 21 July Retrieved 7 November Retrieved 14 June Intel Corporation.

Archived from the original on 4 November The Oregonian. Archived from the original on 26 August Retrieved 23 September Information Gatekeepers. Archived from the original on 12 November Retrieved 23 October Patent Office. Retrieved 4 December PC world.

Archived from the original on 24 January Archived PDF from the original on 30 January Archived from the original on 22 December Retrieved 5 September Business week. Archived from the original on 23 September Popular Mechanics Magazine. Hearst Magazines: February ISSN Archived from the original on 15 February Microchip Technology Incorporated. Archived from the original on 23 March Retrieved 23 March USB Implementers Forum. Archived from the original on 3 December Retrieved 28 April Archived from the original on 6 October Retrieved 13 May San Jose, Calif.

Archived from the original PDF on 31 March Retrieved 22 June — via usb. Join us for a free virtual event on June 22, as award-winning entrepreneur Natalie Cofield discusses small business challenges and strategies to overcome them. Microsoft Premium Office apps, extra cloud storage, advanced security, and more—all in one convenient subscription. For up to 6 people For 1 person. Save on Surface Score incredible deals on select Surface devices for every activity.

Shop Surface Deals. Choose your Microsoft Products for home. Surface Pro 8 Do more with a larger inch touchscreen, faster connections, and extra speed. By default, January 1, , is serial number 1, and January 1, , is serial number because it is 39, days after January 1, To copy the conversion formula into a range of contiguous cells, select the cell containing the formula that you entered, and then drag the fill handle across a range of empty cells that matches in size the range of cells that contain text dates.

After you drag the fill handle, you should have a range of cells with serial numbers that corresponds to the range of cells that contain text dates. Select the cell or range of cells that contains the serial numbers, and then on the Home tab, in the Clipboard group, click Copy. Select the cell or range of cells that contains the text dates, and then on the Home tab, in the Clipboard group, click the arrow below Paste , and then click Paste Special.

On the Home tab, click the popup window launcher next to Number. In the Category box, click Date , and then click the date format that you want in the Type list. To delete the serial numbers after all of the dates are converted successfully, select the cells that contain them, and then press DELETE.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. Convert text dates with two-digit years by using Error Checking. You can use the Error Indicator to convert dates from text to date format. Select the cell, cell range, or column that you want to reformat. Click Number Format and pick the date format you want. The Short Date format looks like this: The Long Date includes more information like in this picture:.

Follow these steps: Select a blank cell and verify that its number format is General. What is an Excel serial number? Need more help? Expand your skills. Get new features first.