Closed Thread
Results 1 to 2 of 2

Add two zeros in front of every cell

Hybrid View

  1. #1
    Registered User
    Join Date
    01-12-2016
    Location
    Europe
    MS-Off Ver
    MS 2013
    Posts
    48

    Add two zeros in front of every cell

    Hi Forum,

    I am seeking to create a macro that can add two zeros in front of every cell, when copying, so that it the cells after can be used for calculations (i.e. not text cells).

    Any help is deeply appreciated

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,704

    Re: Add two zeros in front of every cell

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Add two zeros in front of every number cell
    By ugalskov in forum Excel General
    Replies: 13
    Last Post: 02-17-2016, 07:13 AM
  2. How to put 0000 zeros in front of numbers
    By hendrikbez in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-20-2014, 04:13 AM
  3. Keeping zeros in front of number
    By gronnies in forum Excel General
    Replies: 2
    Last Post: 08-29-2010, 02:09 PM
  4. zeros in front of numbers in cell
    By Nennie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-07-2009, 03:21 PM
  5. zeros at the front of numbers
    By fretwizard in forum Excel General
    Replies: 2
    Last Post: 11-06-2008, 08:19 AM
  6. How do I keep the zeros in front of numbers when i split a cell
    By tom in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2005, 11:05 PM
  7. [SOLVED] How do I get zeros to stay in front of a # when using the concate.
    By czarkzm in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2005, 12: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