Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 3

remove time stamp from date in excel

I have pasted data from project into excel. I have the project dates with a
time stamp 07/14/07 10:12 PM. I want to strip the time portion off from the
date. Format just changes the appearance but does not remove the hidden time
stamp.

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
permanent time and date stamp for Excel --- so it cant be changed	TR clvgis	Excel Discussion (Misc queries)	1	December 30th 06 01:23 AM
EXCEL GLOBAL DATE AND TIME STAMP	BUZZ55	Excel Discussion (Misc queries)	1	December 7th 06 05:21 PM
Date-Time Stamp	[email protected]	Excel Discussion (Misc queries)	1	September 27th 06 02:37 PM
Add time and date stamp to Excel comments.	Ahmed Madkour	Excel Discussion (Misc queries)	2	May 26th 06 01:57 PM
can you date time stamp entries in excel	opinky	Excel Discussion (Misc queries)	1	March 17th 05 04:25 PM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us