Posted to microsoft.public.excel.misc

Posts: n/a

Default Time

It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter
it says 10:00 am. How can I change the default so it is PM.

Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
time entry with am/pm and no colons	Cyrus	Excel Discussion (Misc queries)	9	March 3rd 06 11:42 AM
Formula for a time card	skateblade	Excel Worksheet Functions	6	November 2nd 05 09:28 PM
Setting and KEEPING the default chart	redbelly	Charts and Charting in Excel	0	June 30th 05 02:35 PM
time differences in a column	68magnolia71	Excel Worksheet Functions	3	May 9th 05 09:46 PM
Time Sheet Calculation Help Needed!	sax30	Excel Worksheet Functions	2	April 26th 05 08:08 PM

All times are GMT +1. The time now is 02:06 PM.

About Us

"It's about Microsoft Excel"