Linking to custom number formats

[crew11k]

The issue: I want to display a cell with the value -1,000 as Negative 1,000. In custom number formats I have selected #;"negative" #,###;; which does indeed display the cell with -1000 as Negative 1,000, however, I want to be able to link to this cell and have the link pull in Negative $1,000. Is this possible?

Thanks so much

 

[crew11k]

Perfect, thank you to SRG and Hottpepper for helping solve my custom number formatting issues.