| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date and sequential serial numbers
Hi
I am using a date that i have in an excel sheet in VBA and would like the value to be the sequential serial number and not the date. I am using this value for calculations, and it does not work if the "value" is 12/02/2003 instead 38029 How do I get the value in sequential serial number instead of the date. Rgds Peter B |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| generate serial numbers and date it entered | Excel Discussion (Misc queries) | |||
| Changing text dates to date serial numbers | Excel Worksheet Functions | |||
| Date to TEXT. NOT to sequential serial number | Excel Discussion (Misc queries) | |||
| Renaming Sequential Rows to create serial numbers | Excel Worksheet Functions | |||
| Changing date serial numbers | Excel Discussion (Misc queries) | |||
Threaded Mode
