+ Reply to Thread
Results 1 to 2 of 2

Multiple format in one cell? Possible?

  1. #1
    Registered User
    Join Date
    06-03-2014
    Posts
    1

    Multiple format in one cell? Possible?

    I'm not good at this. I know it. I've never taken a class and know just enough about excel to make me seem like a wizard to non-computer peeps and a Neanderthal to those of you who know what you're doing. Please, please help this Neanderthal!

    I am making a time card/calender thing for work. I want to be able to put a small number in the corner of the cell for the date and then be able to go in and put a larger number in the center of the cell with the number of hours worked. I would very much like to be able to lock the calendar dates so that I don't mess them up, but to be able to change the hour values. Please be VERY detailed with your answer. I know it's probably simple...but probably not to me. Thank you so much!


    Michelle

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,440

    Re: Multiple format in one cell? Possible?

    I think that one approach would be to have two cells per date. The top one would contain the date, formatted as a date, however you wish, and the lower could be for the hours. You'd then format the two cells with interior fill and borders so they look like one cell but they can be formatted separately/individually. You can then lock all the cells with dates in them and unlock those where you want to input hours. if you then protect the sheet, with or without a password, the date cells will be safe.
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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. macro to format one cell of text line to multiple cell
    By mithil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2010, 11:29 AM
  2. Replies: 2
    Last Post: 03-29-2010, 07:07 PM
  3. Format cell color based on multiple cell values
    By Zenaida in forum Excel General
    Replies: 3
    Last Post: 05-09-2006, 06:56 PM
  4. How do you format a cell for % varience for multiple answers
    By Brian, the Acctman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. [SOLVED] How do you format a cell for % varience for multiple answers
    By Brian, the Acctman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10: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