Strange Date Format Bug "Shiva" <alap.ghosh[ at ]gmail.com> 31.08.2006 05:12:44 Hi all, I don't know which subtopic this belongs to. Each time I work with dates in Excel 2003 on my machine, the date, regardless of the format, becomes a number. For e.g. When I type the date 1/1/2006, the Formula Bar shows me, 1/1/2006, but the column actually shows "38718". A different number for each date. I've tried all Date formats in regional settings, nothing works. Can anyone help? Best wishes, Shiva

Re: Strange Date Format Bug "Pete_UK" <pashurst[ at ]auditel.net> 31.08.2006 08:11:53 You should format the cell (or column) - Format | Cells | Number (tab) and choose Date, then you will be given different styles that you can choose from - pick one and click OK. Hope this helps. Pete Shiva wrote: [Quoted Text] > Hi all, > > I don't know which subtopic this belongs to. > > Each time I work with dates in Excel 2003 on my machine, the date, > regardless of the format, becomes a number. > > For e.g. When I type the date 1/1/2006, the Formula Bar shows me, > 1/1/2006, but the column actually shows "38718". A different number for > each date. > > I've tried all Date formats in regional settings, nothing works. > > Can anyone help? > > Best wishes, > Shiva

Re: Strange Date Format Bug Gord Dibben <gorddibbATshawDOTca> 31.08.2006 16:00:59 Not so strange once you understand how Excel stores dates. See Chip Pearson's site for details. http://www.cpearson.com/excel/datetime.htm#SerialDates On 30 Aug 2006 22:12:44 -0700, "Shiva" <alap.ghosh[ at ]gmail.com> wrote: [Quoted Text] >Hi all, > >I don't know which subtopic this belongs to. > >Each time I work with dates in Excel 2003 on my machine, the date, >regardless of the format, becomes a number. > >For e.g. When I type the date 1/1/2006, the Formula Bar shows me, >1/1/2006, but the column actually shows "38718". A different number for >each date. > >I've tried all Date formats in regional settings, nothing works. > >Can anyone help? > >Best wishes, >Shiva Gord Dibben MS Excel MVP

Re: Strange Date Format Bug "Stephen Bye" <stephenbye[ at ]byedesign.freeserve.co.uk> 31.08.2006 20:21:33 Try going to Tools | Options and unchecking 'Formulas'. Or press Ctrl + ` "Shiva" <alap.ghosh[ at ]gmail.com> wrote in message news:1157001164.070535.288820[ at ]e3g2000cwe.googlegroups.com... [Quoted Text] > Hi all, > > I don't know which subtopic this belongs to. > > Each time I work with dates in Excel 2003 on my machine, the date, > regardless of the format, becomes a number. > > For e.g. When I type the date 1/1/2006, the Formula Bar shows me, > 1/1/2006, but the column actually shows "38718". A different number for > each date. > > I've tried all Date formats in regional settings, nothing works. > > Can anyone help? > > Best wishes, > Shiva >