+ Reply to Thread
Results 1 to 4 of 4

Quickly formatting a cell

  1. #1
    Registered User
    Join Date
    02-19-2014
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    2

    Quickly formatting a cell

    Is there a way to quickly format a cell so that it acts as though it is just a number and can still be used in a formula but also have a label? For instance I would like to be able to type in "10cm" and have the cell equal 10 and have it formatted to "General \c\m".

    I realize that this is possible with the cell formatting menu, and can be applied to lots of cells at once, my question is can this be done somehow by just typing into the cell so that I can enter lots of cells that may have different labels without having to go into the cell format menu for each one.

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: Quickly formatting a cell

    custom format as
    General " c.m."

  3. #3
    Registered User
    Join Date
    02-19-2014
    Location
    California
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: Quickly formatting a cell

    I already know how to do this in the formatting menu. I am asking if there is a way to do it while just typing in the cell.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: Quickly formatting a cell

    Short answer, without using VBA - no
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. how to go to a particular cell quickly
    By seraphin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 03:18 PM
  2. Quickly linking cell values to other workbooks
    By Subject_Name_Here in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 01:22 AM
  3. Replies: 2
    Last Post: 02-07-2012, 08:14 PM
  4. HELP!!! need help!and quickly!
    By Brightmaster in forum Excel General
    Replies: 4
    Last Post: 01-03-2007, 12:26 PM
  5. Replies: 4
    Last Post: 01-24-2006, 05:15 AM

Tags for this Thread

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