Thanks I can live with it and it works just fine.

"Ron Coderre" wrote:

Perhaps a Custom Number Format?

With
A1: 2017

Try something like this:
Select A1
From the Excel main menu:
<edit<format<number tab
Category: Custom
Type: General" TOTAL PPs"
Click [OK]

That way the A1 will will display:
2017 TOTAL PPs
...but it will contain the number 2017

Any cells referencing A1 will be able to use the numeric contents.

Is that something you can work with?
***********
Regards,
Ron

XL2003, WinXP


"paulg" wrote:

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?