Date and Time picker formatting help

Ylimer

New Member
Joined
Mar 7, 2009
Messages
2
I have added a date and time picker to my sheet with the pop up calendar. I love it, but I can't seem to set the text alignment in the box. Like, I resized the object to be rather large, but the text just sits in the upper left corner. How can I pull it to the center, both vertically and horizontally?
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Ugh, and while I'm asking, is there anyway to hide the arrow for the menus when printing. It's not too important, but for aesthetic purposes.

I was going to use plain ole drop down menus to do the date, but I'm trying to make this form as user friendly as possible. It is basically an order form and I need a date picker for "pick up times." So this data will never be on a website. Just printed.
 
Upvote 0

Forum statistics

Threads
1,207,166
Messages
6,076,902
Members
446,239
Latest member
Home Nest

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top