Results 1 to 4 of 4

Start typing from left hand side? (Within Cell)

Threaded View

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    45

    Start typing from left hand side? (Within Cell)

    Is there any ways to make it so when you start typing, the numbers start from the left hand side of your custom format?

    Basically I want to make a cell that has a job number, but I want it to be able to have a total of 5 changeable numbers.

    I want the last one to be unnecessary, so I can make a job number that goes up above 99, but only shows itself after I have past that threshold.

    IE.)

    Custom Format is

    00-00#

    If I type 0101 it shows

    01-01

    which leaves the last value blank.
    Last edited by Dagoom; 03-11-2015 at 10:29 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Function Call on left-hand side... error
    By SeanDamnit in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2012, 07:08 AM
  2. Need to Insert Labels on Left and Right Hand Side of Graph
    By John Vieren in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2009, 09:29 AM
  3. Replies: 1
    Last Post: 03-13-2005, 01:06 PM
  4. [SOLVED] y-axis moves from the left hand side to the right hand side!
    By JP in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-10-2005, 09:06 PM
  5. How do I get my y axis on the left hand side of my chart?
    By Aneleh in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-08-2005, 02:06 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