Posted to microsoft.public.excel.worksheet.functions

Janet Kreinbrink[_2_] Janet Kreinbrink[_2_] is offline

external usenet poster

Posts: 4

Format dates from cvf file

Figured it out:

=TIME(A1/100,MOD(A1,100),0)

Thanks!

"Janet Kreinbrink" wrote:

Tried that, but got this message: Microsoft Office Excel cannot use the
number format you typed.

"bob" wrote:

try using this custom frmat: [h]:[m]

"Janet Kreinbrink" wrote:

Hi,
I have a large spreadsheet of data from a cvf file. Column B has the time
in this format: 1700. Can't for the life of me figure out how to chage it to
miliary time (17:00).

Thanks.

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
Link from Chart File to Data File / Format Problem	Brad Bross	Charts and Charting in Excel	0	July 31st 08 10:15 PM
CONVERT DATES FROM EUROPEAN FORMAT TO US FORMAT	les8	New Users to Excel	8	August 8th 06 05:48 PM
Format text 'dates' to real dates	Jacy	Excel Worksheet Functions	4	July 24th 06 02:10 AM
How do I autosave a unique Excel file in the file format 03F67000	flyboy06	Setting up and Configuration of Excel	1	June 14th 06 11:11 PM
the dates on cell format make different dates.	date formats morph the dates/chang case	New Users to Excel	6	April 18th 05 02:41 AM

All times are GMT +1. The time now is 12:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us