Not that I know, but if you use styles, as in Word, you could do this in one
step as opposed to changing every single cell.

--
Regards,

Juan Pablo González
Excel MVP

"Bobak" wrote in message
...
Is it possible to link a custom number format to a cell within a workbook?

Currently I have the number format
#,##0.0"m (forecast)";(#,##0.0)"m (forecast)";-"m (forecast)"
used extensively throughout a workbook

I want to change the text after each number to "m (actual)". I will be
changing the text on a monthly basis. Currently I have to manually change
the
format each month.