View Single Post
  #1   Report Post  
Bobak
 
Posts: n/a
Default Linking customer number format to a cell

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.