Thanks everyone for your responses

"Rick Rothstein (MVP - VB)" wrote:

This function call will pull out the leading number from a cell...

LOOKUP(9.9E+307,--LEFT(A1,ROW($1:$99)))

It returns a #N/A error if there is no number in the cell, so you may want
to wrap it in an IF function call if that is a possibility.

Rick


"paulg" wrote in message
...
I would like to avoid using two cells to represent the following:
2017 TOTAL PPs. (all in one cell)
I would like to use only the number part of the cell contents in a
formula.
Can it be done?