Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pop-up julian date
hello,
the following steps show hoe to insert regular date. what iam looking for to insert julian date instead. Any idea how???????? 1. View..ToolBars...Control Toolbox 2. Click the button for More controls (looks like two hammers) 3. From the list Select "Microsoft Date Time Picker " 4. Drag on sheet for the size of the control 5. Turn off design mode (green triangle on the control toolbox) to use the DT control -- samy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pop-up julian date
This doesn't pop-up, but it does calculate the Julian date. The example
below uses A1 as the cell that contains the date: =A1-DATE(2008,1,0) -- Kevin Backmann "samy" wrote: hello, the following steps show hoe to insert regular date. what iam looking for to insert julian date instead. Any idea how???????? 1. View..ToolBars...Control Toolbox 2. Click the button for More controls (looks like two hammers) 3. From the list Select "Microsoft Date Time Picker " 4. Drag on sheet for the size of the control 5. Turn off design mode (green triangle on the control toolbox) to use the DT control -- samy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Julian date - find next highest date/number | Excel Worksheet Functions | |||
Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
to convert a julian date back to regular date | Excel Worksheet Functions | |||
Convert a julian gregorian date code into a regular date | Excel Worksheet Functions | |||
how to convert julian date to regular calendar date | Excel Worksheet Functions |