Posted to microsoft.public.excel.misc

CMIConnie

Posts: n/a

can't format column for date

I have a spreadsheet and I need to format the date column to read as a date.
Can anyone explain why Excel refuses to apply my date format and continues to
show the date as an obscure 5 digit number? How can I get Excel to accept
the format I need? Thank you! (I am using Excel 2002)

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 format based on data from another column	Ellie	Excel Discussion (Misc queries)	3	May 14th 08 05:23 PM
format macro	Jonathan Cooper	Excel Discussion (Misc queries)	5	January 9th 06 08:49 PM
Positioning Numeric Values Resulting from 6 Column Array Formula	Sam via OfficeKB.com	Excel Worksheet Functions	2	January 5th 06 02:03 AM
match and count words	David	Excel Worksheet Functions	5	July 4th 05 02:24 AM
Format Column with Same Function	Brett Patterson	Excel Worksheet Functions	6	January 5th 05 07:43 PM

All times are GMT +1. The time now is 05:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us