+ Reply to Thread
Results 1 to 2 of 2

Entering multiple fractions in a cell

  1. #1
    Registered User
    Join Date
    08-17-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2007
    Posts
    2

    Entering multiple fractions in a cell

    Hello everybody, I am starting to catalogue my stamp collection in excel. In one of the columns I am entering the demonination of the stamp/s used on stamp covers. Problem I have come up against is that Excel will not allow me to insert no more than 1 fraction number in the same cell. The following is an example of what I want in the same cell ½d,1d,1½d,2d. The only way I can think of doing this is to use 1 column for each number. For example, column H=½d, I=1d, J=1½d, K=2d, (a bit ugly). I would welcome any help on this please. Thank you.

  2. #2
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Entering multiple fractions in a cell

    Hi

    Only way I can think of is to enter your values as a text string with ="1/4p,1/2p,"

    Hope that helps

    Chris

+ 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