Results 1 to 11 of 11

Roundup and add leading zeros if less than 100 in a referenced cell from a range

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2020
    Location
    London, England
    MS-Off Ver
    365
    Posts
    78

    Roundup and add leading zeros if less than 100 in a referenced cell from a range

    Hi experts,

    I have a specific requirement where I have a range list to select a number, from 1 to 150.
    This value is then selected and used in the contents of another cell.
    This is simple enough. I also need to use it in another cell but rounded up to the next 10, also simple enough.
    What I can't find out, is how to get to to 3 digits, leading with zeros.
    So 1 would become 010 (rounded up).
    15 would become 020
    105 would be 110
    Then add in a word from another range and piece these two together in another cell in the perfect format...
    030 Goats if I select "25" and "Goat"
    etc.
    See attached for this.
    Also, how to add a plural if > 1?
    In this scenario, it will always be more than one, but for reference, how could it add plural if it didn't round up?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Format Cell to Text and Add Leading Zeros
    By hnguy71 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-24-2018, 02:17 PM
  2. combine cells where one cell has leading zeros
    By galetondesigns in forum Excel General
    Replies: 7
    Last Post: 09-20-2012, 04:20 PM
  3. formatted cell with leading zeros
    By ssdsibes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2009, 08:10 PM
  4. Add leading zeros to existing data in a cell
    By jpartney in forum Excel General
    Replies: 1
    Last Post: 03-19-2008, 02:08 PM
  5. [SOLVED] Format a cell to keep leading zeros.
    By Shadyhosta in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-27-2005, 11:37 AM
  6. [SOLVED] How do I force leading zeros in an Excel cell?
    By EricKei in forum Excel General
    Replies: 2
    Last Post: 06-15-2005, 04:05 PM
  7. Replies: 1
    Last Post: 05-04-2005, 02:06 PM

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