+ Reply to Thread
Results 1 to 2 of 2

Adding number to a cell without making it possible to edit / Calendar

  1. #1
    Registered User
    Join Date
    01-23-2019
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Windows 2016
    Posts
    49

    Adding number to a cell without making it possible to edit / Calendar

    Howdy

    I need to insert the day in a cell square without making it possible to edit or remove it

    Kind like this
    Capturar.PNG

    I wonder if its possible to keep the number detached from the cell contents. In a way i can edit the cell without editing that number.

    I want to get a calendar running and this would be a good way to do so

    Thanks in advance

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Adding number to a cell without making it possible to edit / Calendar

    You can't do that, but what you could do is put the date in the cell above and lock it. Fill the cells with a white background (so the grid lines disappear) and enclose both cells in a single border so it LOOKS like a single cell.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Adding Date picker to a cell (a calendar popup)
    By theglitch in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2015, 08:01 AM
  2. [SOLVED] Making a cell = 0 if a range contains "Edit"
    By Tyrae21 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2013, 12:39 PM
  3. Adding a Calendar for quick cell input
    By ImagineParidise in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-15-2012, 03:23 AM
  4. Replies: 0
    Last Post: 08-31-2011, 09:44 AM
  5. Replies: 3
    Last Post: 09-06-2010, 02:31 PM
  6. Adding up the digits making up a number in a cell
    By Geir in forum Excel General
    Replies: 8
    Last Post: 04-16-2009, 09:58 AM
  7. [SOLVED] Making calendar with numbers and text in same cell
    By yankeybeans in forum Excel General
    Replies: 0
    Last Post: 10-13-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1