View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyer
 
Posts: n/a
Default separate numbers that have a / between them

How do you intend to quantify the case capacity for each individual item?

In other words, what tells XL which item has 6 per case, and which item has
200 per case?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"widman" wrote in message
...
A software program I have generates all stock or movement in full/partial
format, so if I have 10 full cases and a case with 4 of 6 items in it, it
represents inventory as
10/4. A case of 200 might show 4/198 meaning 4 full and 198 loose. It

does
the same for sales, inventory, etc.

How can I convert this into something usefull, like 10.67, or even rounded
to 11?