Posted to microsoft.public.excel.misc

Benny

external usenet poster

Posts: 16

Excel time conversion issue

I imported some data into excel. Time values were in military format but
when moved to excel the values change. Tried to convert back to military
time using format cells but this does not work. For example, 0500 changed to
something like 1123 in excel.

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
XML to Excel conversion issue	Nirad	Excel Discussion (Misc queries)	1	June 19th 07 05:26 PM
File conversion-text encoding issue	elhirsch	Excel Discussion (Misc queries)	2	September 11th 06 03:19 PM
Vlookup text conversion issue	PamKT	Excel Discussion (Misc queries)	2	August 28th 06 05:59 PM
Date conversion issue... again	Dimmer	Excel Discussion (Misc queries)	6	July 11th 05 04:11 PM
Date conversion issue "^" symbol	Shannon	Excel Discussion (Misc queries)	1	May 4th 05 12:25 AM

All times are GMT +1. The time now is 09:55 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us