Help Creating a custom format for one cell??

I want to create a custom format for a cell for entering in "cup measurements". I want to be able to type in 5, 1/4, 1/16, etc. and have the word "cups" appear after the number in that cell. I formatted the cell to say the word cups after typing in the numbers in my cell using the code "cups".

ex: 0 "cups" works fine for whole number

so then if i change it to 0/0 "cups" is works great for only 1/8 but not 1/16 or whole numbers. Then I looked at other custom codes that already existed in my formatts so I attempted to try this code which I just kinda came up with

_(0/00);_(0);_(0/0); "cups"

well it isn't doing what I want and If I use the 0/00 "cups code and I type in 4 cups the cell then says 4/01 cups.

What does my code need to be for me to show whole numbers and and size fraction without having it look weird?

I appreciate any help!

Hi -

Try the following format:

# ??/?? "Cups"

Hope that helps.

You are AWESOME!!! This did exactly what I was looking for. Thank you so much for the help.