Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Custom cell view / value

  1. #1
    Board Regular
    Join Date
    Feb 2011
    Posts
    55
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Custom cell view / value

    I would like to present a data in a cell in a special way, e.g.
    1423 / (4837)
    but the actual cell value would be 1423. So if this cell is used e.g. for summary, the summary function uses only that first number. Is this possible to do?

  2. #2
    Board Regular
    Join Date
    Aug 2011
    Posts
    2,932
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Custom cell view / value

    Hi,

    You can do this with custom number formatting. There are limits to what you can do with it, but for your specific example, a format like this might work:

    0000" / (4837)"

    To learn more about custom number formatting see:
    Create or delete a custom number format - Excel - Office.com
    Excel Custom Formats: Numbers/Text Formats in Excel Spreadsheets
    Custom Number Formats (Multiply & Divide by any Power of 10) | Chandoo.org - Learn Microsoft Excel Online

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •