Custom number format to replace blank with "text"

[excelos]

Hello

What would be the custom number format to replace blank with "text"?

I tried ;;”text" or "text" with conditional formatting but it didn't work.

Thanks!

 

[Fluff]

You cannot use a custom cell format to put text into an empty cell.

 

[Joe4]

You would probably need to use VBA to do something like this, but then you need to determine how/when the VBA code would run.
Would someone run it manually, or should it happen auotmaitcally upon some event happening?
If so, what situation/action would trigger the code to run?

 

[DanteAmor]

If you write a blank, then it returns "text"
Try:

;;;"text"