Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combining Variables Into A Single Output Cell
Hi Folks,
I've been working with some database data which stores the date as an integer (a different integer to that which Excel uses). To calculate the day, month and year I do the following calculations: y = Fix(ActiveCell / 65536) m = Fix((ActiveCell - (y * 65536)) / 256) d = Fix((ActiveCell - (y * 65536)) - (m * 256)) I now want to combine d, m and y into a single cell in the format off dd/mm/yyyy but don't have a clue how anyone able to help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combining data with the same ID and the similar variables | Excel Discussion (Misc queries) | |||
Combining Formula and Data Validation List in a Single Cell | Excel Worksheet Functions | |||
How to store variables of a single cell in a column? | Excel Programming | |||
From single cell variables to a single column serie | New Users to Excel | |||
Combining numerical and drop-down text in a single cell | Excel Discussion (Misc queries) |