+ Reply to Thread
Results 1 to 3 of 3

Simple - Adding "=" to a cell with exsisting values

  1. #1
    Registered User
    Join Date
    02-17-2010
    Location
    new york
    MS-Off Ver
    Excel 2007
    Posts
    45

    Simple - Adding "=" to a cell with exsisting values

    This should be fairly simple. I have a column with X number of values and I'm trying to insert "=" at the begining of each cell data with a macro.

    Existing data:
    56
    545
    55
    54


    Need:
    =56
    =545
    =55
    =54

    Any help would be appreciated.

  2. #2
    Valued Forum Contributor
    Join Date
    07-17-2005
    Location
    Abergavenny, Wales, UK
    MS-Off Ver
    XL2003, XL2007, XL2010, XL2013, XL2016
    Posts
    608

    Re: Simple - Adding "=" to a cell with exsisting values

    Hi

    If you select the range of cells and run this code, it should do what you want.
    Alternatively, you can set the range you want to act upon within the code itself.

    Please Login or Register  to view this content.
    --
    Regards
    Roger Govier
    Microsoft Excel MVP

  3. #3
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Simple - Adding "=" to a cell with exsisting values

    Alternatively:

    Please Login or Register  to view this content.
    If you wish to handle other data types you will need to adjust accordingly

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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