| 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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combining Variables Into A Single Output Cell
vba help index
DateSerial Function Returns a Variant (Date) for a specified year, month, and day. Syntax DateSerial(year, month, day) -- Don Guillett SalesAid Software "Chergh" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Combining Variables Into A Single Output Cell
Thanks very much works perfectly :)
"Don Guillett" wrote: vba help index DateSerial Function Returns a Variant (Date) for a specified year, month, and day. Syntax DateSerial(year, month, day) -- Don Guillett SalesAid Software "Chergh" wrote in message ... 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? |
| Reply |
| 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) | |||
Hybrid Mode
