+ Reply to Thread
Results 1 to 4 of 4

Possible to add content to multiple cells at once?

  1. #1
    Registered User
    Join Date
    10-06-2009
    Location
    Burlington, VT
    MS-Off Ver
    Excel 2007
    Posts
    2

    Possible to add content to multiple cells at once?

    Is there any edit the content (add an equals sign to the beginning) of multiple cells at once? I have a large amount of data that was entered as fractions. I need to convert it to percentages but it will take forever to add an equals sign to each cell. The cells are formatted to general and I tried changing them to number or fraction, but neither worked.

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: Possible to add content to multiple cells at once?

    hummmm, you should be able to select and format to percentages all at once- do you want to post an example from your workbook?

  3. #3
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Possible to add content to multiple cells at once?

    can u upload dummy work-k
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  4. #4
    Registered User
    Join Date
    10-06-2009
    Location
    Burlington, VT
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Possible to add content to multiple cells at once?

    I attached an example. Also, the formatting of column D is pretty weird. When I try to change the format from date to general the numbers change (ex: from 4/10 to 39913).
    Attached Files Attached Files

+ 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