| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
If you format the column as text before entering the date, it should stay as
text. -- David Biddulph "mrbalaje" <(E-Mail Removed)> wrote in message news  D90AEBB-3A6E-4A05-9059-(E-Mail Removed)...>I have several date range in one Column. When I enter the date as > 22-Aug-2007, it automatically changed to a number starting 39XXXXX. > > I know I can reformat the date, but there are several other date range in > the same column such as 4Q07, 1Q08... and 2007, 2008 etc. Hence I need to > have the column format as text to have 4Q07.... > > Can anyone help me on this? > > |
|
|
|
|
|||
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Changing the date format on the date table in a chart | spudsnruf | Microsoft Excel Charting | 2 | 3rd Sep 2009 07:08 PM |
| Changing Date Format? | SWFisherman | Microsoft Access | 4 | 9th Mar 2009 08:16 PM |
| changing date formatted as general number into date format | =?Utf-8?B?cGdoaW8=?= | Microsoft Excel Programming | 4 | 2nd Mar 2007 05:17 PM |
| Changing the date format & adding the date range to the header | =?Utf-8?B?UHVyZUV2aWw=?= | Microsoft Access | 1 | 6th Oct 2006 11:31 PM |
| Re: Changing date serial numbers to date format | Bob Umlas | Microsoft Excel Discussion | 0 | 14th Apr 2005 12:58 PM |
