ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   changing the month on an inserted calendar in excel (https://www.excelbanter.com/excel-discussion-misc-queries/131202-changing-month-inserted-calendar-excel.html)

don1592

changing the month on an inserted calendar in excel
 
When you insert a calendar (Calendar control object) is there a process to
format the month as it defaults to todays date


Teethless mama

changing the month on an inserted calendar in excel
 
Assuming a link cell in A1 from calendar control object

In B1: =--A1
format cell as: mmmm

"don1592" wrote:

When you insert a calendar (Calendar control object) is there a process to
format the month as it defaults to todays date



All times are GMT +1. The time now is 11:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com