RE: I need a static date/time in Excel. As stated above, you'll need VBA to have the date/time automatically entered into a cell. But just an FYI: [Ctrl]+[;] enters the current date. [Ctrl]+[Shift]+[;] enters the current time. Those entries are not formulas, so they will remain static once entered.If you want both the date and time in a single cell, then you need to add a space between the two: [Ctrl]+[;], [Space], [Ctrl]+[Shift]+[;] enters the current date and time.-John.hose entries are not formulas, so they will remain static once entered. If you want both the date and time in a single cell, then you need to add a space between the two: [Ctrl]+[;], [Space], [Ctrl]+[Shift]+[;] enters the current date and time. -John.
Oct 04, 2011, 10:20 PM. We are moving back to the West Coast in December but would like to take our children (7 and 5) to see the Christmas decorations in New York. It looks like the Rockerfeller Christmas Tree will be lit November 30, 2011.
Christmas at Macy's (left) and Rockefeller Center (right). Christmas in New York City is brighter and more embellished than anywhere else. During the holiday season, the city is adorned with beautiful lights and decorations that are sure to put anyone in a festive mood.