| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba - change column "type"
Hi,
I have a csv that gets opened in excel. One column contains cells with the format of Date (mm/dd/yyyy). I need to get the difference between this date and the date in another column. My problem is that the format of the other column is shown as "Custom" (m/d/yyyy h:mm). Is there a way to get the custom column to be the same format as the first column so that I can do a datediff? Thanks, MJ |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba - change column "type"
Hi
if these values are both stored as real date values you can simply use =DATEDIF(INT(A1),INT(A2)) -- Regards Frank Kabel Frankfurt, Germany "MJ" schrieb im Newsbeitrag om... Hi, I have a csv that gets opened in excel. One column contains cells with the format of Date (mm/dd/yyyy). I need to get the difference between this date and the date in another column. My problem is that the format of the other column is shown as "Custom" (m/d/yyyy h:mm). Is there a way to get the custom column to be the same format as the first column so that I can do a datediff? Thanks, MJ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
| Change data in a single column from "last, first" to "first last" | Excel Discussion (Misc queries) | |||
Linear Mode
