Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date format and concatenation
Hello -
I have info in two cells that needs to be concatenated into one cell (Cell E30) as follows: (Some 8-digit number)(hyphen)(date in format of yyddmm).xls An example would be 87654321-052808.xls The 8-digit number is in cell H16 and the date is in cell H18. The format for the date cell is set at dd/mm/yyyy. I've tried putting this into a function, but keep getting errors. Any suggestions will be immensely appreciated. -- Sandy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date Concatenation | Excel Worksheet Functions | |||
Date in Concatenation | Excel Discussion (Misc queries) | |||
Format and Concatenation | Excel Discussion (Misc queries) | |||
Trouble with concatenation number format | Excel Worksheet Functions | |||
format/concatenation | Excel Worksheet Functions |