Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in Excel 2003
Hello All: I need to perform some operations on an Excel 2003 spreadsheet
with about 13,000 rows. I need some macro code to perform the following on each row: 1. Change the date in Column C from the dd/mm/yyyy format to mm/dd/yyyy format. 2. Concatenate the newly formatted date in column C with the time from column D, which if formatted as hh:mm; then store the result in column C as mm/dd/yyyy hh:mm. (Note one space between the last digit of the year and the beginning of the time.) Any help is appreciated. Thanks, Jack Gombola |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates in Excel 2003
You can have a helper column say Col E with the formula
=C1+D1 and format it as you want... mm/dd/yyyy h:mm You can also copy and paste special as values over Col C once you are happy with the result. "JackGombola" wrote: Hello All: I need to perform some operations on an Excel 2003 spreadsheet with about 13,000 rows. I need some macro code to perform the following on each row: 1. Change the date in Column C from the dd/mm/yyyy format to mm/dd/yyyy format. 2. Concatenate the newly formatted date in column C with the time from column D, which if formatted as hh:mm; then store the result in column C as mm/dd/yyyy hh:mm. (Note one space between the last digit of the year and the beginning of the time.) Any help is appreciated. Thanks, Jack Gombola |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with dates!! Excel 2003 | Excel Discussion (Misc queries) | |||
Dates in Excel 2003 | Excel Discussion (Misc queries) | |||
Dates in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 dates | Excel Discussion (Misc queries) | |||
dates in Excel 2003 | Excel Discussion (Misc queries) |