Posted to microsoft.public.excel.misc

Question Boy Question Boy is offline

external usenet poster

Posts: 25

Formatting Date

I have a column which contains dates

2008-Jan-10

I have tried changing the cell format, but it has no effect. I have tried
using the Text(..,"yyyy-m-d"), but it has not effect. How can I change the
format so it is formatted like yyyy-m-d?

Thank you

QB

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
conditional formatting for cell date to equal today's date	Sistereinstein	Excel Worksheet Functions	2	September 10th 12 07:53 PM
Formatting as date	gwplotts via OfficeKB.com	Excel Worksheet Functions	3	April 17th 07 03:09 PM
Date formatting	Hawksby	Excel Discussion (Misc queries)	2	December 15th 06 02:45 PM
Formatting Date	newguy	Excel Discussion (Misc queries)	4	September 18th 06 01:49 PM
Help with formatting the date.	Lee	Excel Discussion (Misc queries)	6	February 24th 06 07:27 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us