| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to assign Time and Date into cell?
mycell.offset(0,1).value = Time
mycell.offset(0,1).value = Date Does anyone have any suggestions on how to assign Time and Date into cell? Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to assign Time and Date into cell?
MyCell.Offset(0, 1).Value = Now
Mike "Eric" wrote: mycell.offset(0,1).value = Time mycell.offset(0,1).value = Date Does anyone have any suggestions on how to assign Time and Date into cell? Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to assign Time and Date into cell?
Check your other thread, too.
Eric wrote: mycell.offset(0,1).value = Time mycell.offset(0,1).value = Date Does anyone have any suggestions on how to assign Time and Date into cell? Thanks in advance for any suggestions Eric -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Linear Mode
