Answer Line: Create a Start-Up Floppy for Windows 2000 and XP

By Lincoln Spector, PCW Print May 21, 2002 1:00 PM

Time-Stamping in Excel

It's easy to date or time-stamp a Microsoft Excel worksheet. To insert the date, press Ctrl-;. For the time, press Ctrl-Shift-;. To stamp the time and date, press Ctrl-;, the spacebar, and then Ctrl-Shift-;. To turn these keystrokes into a macro, select Tools, Macro, Record New Macro, give the macro a name, assign it a shortcut key combination, and press OK. Insert the date and time as described above, and then press the recorder bar's stop icon. To add dates and times that update automatically, append the =today() and =now() functions to your macro.

Send questions to answer@pcworld.com. We pay $50 for published items. You'll find Contributing Editor Lincoln Spector's humorous writing at www.thelinkinspector.com.

« Prev
Page 6 of 6

Would you recommend this story? YES NO

Subscribe to the Digital Gear Review Newsletter - weekly

See All Newsletters »

Similar Articles:

Answer Line

Remove Unchecked Items from MSConfig After reading Windows Takes Too Long to Boot, Mark Fraleigh went to MSConfig and unchecked several programs. Now he wants to remove them from MSConfig, altogether.
Remove a Program That Lacks an Uninstaller Billiebong wants to remove a program that lacks an uninstaller, and turned to the Utilities forum for help.
Run XP Software in Windows 7 SIUC asked the Windows forum about running software intended for Windows XP in Windows 7
Find Good Medical Advice on the Web Spiderowych asked the Answer Line Forum to recommend medical information Web sites.

Best Prices on Laptops

Inspiron 15 Laptop Computer- Intel Core i3-390M processor (2.66GHz with 3MB Cache) $399.99 and up See All Prices
Inspiron 14R Laptop Computer- Intel Core i3-2350M processor (2.30 GHz) $549.99 and up See All Prices
XPS 15z 15.6" Silver Notebook $999.99 and up See All Prices
XPS 15 15.6" Silver Notebook $1074.99 and up See All Prices

See all Best Prices on Laptops »

See also: Best Prices on Desktops, Servers, Printers, Monitors

All PCWorld Blogs

SpaceX's Dragon Capsule Splashes Down, Historic Mission Comes to an End The firstever docking mission of the ISS by a commercial company has come to an end, and the Dragon capsule returned to Earth safely with return-cargo onboard.
Intel Intros Dual-Core Ivy Bridge Chips; Releases Sneak Peek of Upcoming Ultrabooks The chipmaker also ramps up the standards for Ultrabooks.
Five Fun and Geeky Alternatives to Instagram Is Instagram too mainstream for you? Check out five alternatives for the geek that loves their photo filters.
How to Download and Install the Microsoft Windows 8 Release Preview The latest fine-tuned beta version of Window 8 is now available for your testing pleasure. It's free.

Subscribe to the Digital Gear Review Newsletter - weekly

See All Newsletters »

12 Criteria for Selecting the Best ERP System Replacement An ERP system is your information backbone and reaches into all areas of your business and value chain. Replacing it can open unlimited business opportunities. This white paper explains the 12 criteria that allow you to identify and select the solution that will meet these expectations.
Leveraging Social Computing Technologies for ERP Applications This white paper details how Web 2.0 technologies support business strategies by improving efficiency, productivity, and collaboration.

Today's Special Offers

Editors' Picks

Name	City

Address 1	State	Zip

Address 2	E-mail (optional)