Bolt pattern or bolt circle is the diameter of an imaginary circle formed by the centers of the wheel lugs. Bolt patterns can be 4-, 5-, 6-, or 8-lug holes. A bolt circle of 4x100 would indicate a 4-lug pattern on a circle with a diameter of 100mm.
1. Select a cell that you want to insert current year, month or day, and click the Kutools > Insert > Insert Date, see screenshot: 2. In the Insert Date dialog, check the Using format option, and then double click a date formatting in the right pane. See screenshot above:
Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Learn how to Automatically display the current date every day in Excel. This tutorial shows you a useful formula which will update the spreadsheet every day to show the current day of the week, day, month, and year. You will also learn how to format dates in Excel so that you can display the date exactly how you want to, in any format.