|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 18th, 2009, 10:52 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Formatting hours of .csv file
I have a .csv file that is populated with hours (for example 28:53 when open
as text file) When I open it in excel it automatically formats any hours that exceed 24:00 as a time & date (for example 28:55 imports 01/01/1900 07:54:00, and when I format it as [h]:mm:ss it displays 31:54:00) If the data reads less than 24:00 ie 18:45 it will display 18:45 How caN i COEERCT THIS? 
|
|
#2
May 18th, 2009, 10:58 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Formatting hours of .csv file
Take control of the import:
1. Open Excel 2. Data Import External Data Import Data and then tell the Wizard which file to open The Wizard will allow you to specify the field formats. -- Gary''s Student - gsnu200853 "The Rook" wrote: I have a .csv file that is populated with hours (for example 28:53 when open as text file) When I open it in excel it automatically formats any hours that exceed 24:00 as a time & date (for example 28:55 imports 01/01/1900 07:54:00, and when I format it as [h]:mm:ss it displays 31:54:00) If the data reads less than 24:00 ie 18:45 it will display 18:45 How caN i COEERCT THIS?
|
|
#3
May 18th, 2009, 11:10 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Formatting hours of .csv file
WORKED A TREAT THANKS
"Gary''s Student" wrote: Take control of the import: 1. Open Excel 2. Data Import External Data Import Data and then tell the Wizard which file to open The Wizard will allow you to specify the field formats. -- Gary''s Student - gsnu200853 "The Rook" wrote: I have a .csv file that is populated with hours (for example 28:53 when open as text file) When I open it in excel it automatically formats any hours that exceed 24:00 as a time & date (for example 28:55 imports 01/01/1900 07:54:00, and when I format it as [h]:mm:ss it displays 31:54:00) If the data reads less than 24:00 ie 18:45 it will display 18:45 How caN i COEERCT THIS?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
