Posted to microsoft.public.excel.misc

Lost on the West Coast Lost on the West Coast is offline

external usenet poster

Posts: 1

format trouble

cannot get excel to display date data in date format (have same problem in
next column with currency)?Invoice Invoice
Date Amount
1930
39272 7739
39286 1609.16
39308 335.5
39335 3000
39380 90
39401 200
39394 180
39415 501

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
Trouble with concatenation number format	FJ	Excel Worksheet Functions	2	March 4th 07 04:39 AM
Trouble with concatenation number format	Gary''s Student	Excel Worksheet Functions	0	March 3rd 07 03:09 AM
Trouble with concatenation number format	FJ	Excel Worksheet Functions	0	March 3rd 07 03:02 AM
Conditoinal format trouble	bludovico	Excel Discussion (Misc queries)	3	June 16th 06 04:35 PM
Excel date format trouble	michaelberrier	Excel Discussion (Misc queries)	2	April 21st 06 05:21 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us