I'm thinking your single example is not all encompassing as far as what you
really want; but, for the question you actually asked, you could Custom
Format the cell. Select the cell or cells you want to have "ltrs/hr" apply
to, click Format/Cells on the menu bar, select Custom from the Category list
and put this in the Type field...

0" ltrs/hr"

If you need decimal values, then decide on how many and put this (I'll
assume two decimal places) in the Type field instead...

0.00" ltrs/hr"

--
Rick (MVP - Excel)


"BG" wrote in message
...
Can anyone tell me how to combine text and numbers in the same cell so
that
only the number is a value e.g. Fuel at 17 ltrs/hr This would be entered
into
one cell but could be used as part of a formula where only the number 17
is
used?
--
BG