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.
This year, the Rockefeller Center Christmas Tree lighting ceremony for the dead Norway spruce will take place on Nov. 30 from 7 p.m. to 9 p.m. Eastern and be coupled with live performances. If prospective viewers can't make it to Times Square for the lighting ceremony, however, there's still plenty of time to fawn over the dead tree.