Posted to microsoft.public.excel.misc

Gayla

external usenet poster

Posts: 30

Date Format Problem

I have downloaded data from our time keeping system which has dates in format
of M/D/YR (1/3/07) i would like them in the format of MM/DD/YY (01/03/07). I
have tried date value formula, text to columns and format date options and I
just get value error. I tried converting using error checking but that did
not work either.
Any suggestions.

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
Date format problem	Vass	Excel Worksheet Functions	7	April 3rd 06 04:50 PM
Date Format problem	nastech	Excel Discussion (Misc queries)	2	January 18th 06 01:54 AM
Date conditioning format problem	[email protected]	Excel Discussion (Misc queries)	1	November 1st 05 09:37 AM
date format problem	Nigel	Excel Discussion (Misc queries)	7	May 11th 05 12:57 PM
Problem with Date format from VBA code	twig	Excel Discussion (Misc queries)	3	December 7th 04 06:01 PM

All times are GMT +1. The time now is 03:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us