Search results

Microsoft Date and Time Picker Control 6.0 (SP4)

A1 B1 1234-TL TRAILER LOADER If cell A1 contains "-TL" how can I format B1 to read "TRAILER LOADER"

I am using the Date and Time Picker in a simple, very simple, shift report file. Every I open up the file, two different cells open w/the date and time picker. One is 1 col wide and 3 rows long, the other is just a single cell, yet its obscured by the larger date and time picker. If i select...

NEVER MIND W/A LITTLE PERSISTENCE AND PATIENCE I FIGURED IT OUT. ALL OUT OF PATIENCED

I have a macro enabled workbook that uses the date and time picker in numerous cells it also uses a check box in numerous cells. I was using it last wk to test the format... This week if I open it, I can't minimize, restore up/down or close out the work book or Excel. I have to use the task mgr.

thxs

Happy Monday I have an equipment downtime document (Excel 2007). F2 has the start date of the equipment downtime that uses the MS Date and Time Picker. G2 has the time, that is selected from a drop down list. L2 has the end date (using the dtpicker) and M2 has the end time, selected from drop...

Does anyone have any luck experience setting up a pop up calendar in Excel 2007?

A1 B1 C1 CB 0001- 1-CB A1 B1 C1 -When "Show Formulas" selected CB 1 =CONCATENATE(B2, "-",A2) Question: A1 and B1 are combined and reversed. B1 uses custom format of 0000- to go from 1 to 0001-. Result is 1-CB. How do I get C1 to come up w/0001-CB.