+ Reply to Thread
Results 1 to 2 of 2

Formatting

  1. #1
    Registered User
    Join Date
    07-25-2011
    Location
    Sydney
    MS-Off Ver
    Excel 2010
    Posts
    4

    Formatting

    hi everyone

    first off i apologise if i am posting this in the wrong area as this is my first question

    i am having a little bit of trouble with my formatting

    i want to create a cell format so that the following text

    70.1
    A12-10
    A1-9.1
    A1.1
    50

    converts to

    <70.1>
    <A12-10>
    <A1-9.1>
    <A1.1>
    <50>


    as you can see i would like the formatting to add the brackets and bold the font and change it to red

    but when i try to do so i can't seem to create a format where it works for all the combinations, what i mean it that the formatting that i put is not universal and will either leave a . or something

    is there anyway that i can set the formatting so that it works?

    thank you in advance

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: Formatting

    Hi Rblood, welcome to the forum.

    Try setting the cells' custom format to:

    [Red]"<"General">";[Red]"<-"General">";[Red]"<"General">";[Red]"<"@">"

    This should display all positive, negative, zero and text values within brackets and retain the entire cell value.

+ 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