Conditionally Fill Cell With Text

[Freezerburn]

Is it possible...to have a cell contain a formula in which the value within the cell is automatically something if nothing else was manually entered in that specific cell?

For example, I would want a certain cell to always be "--" if no other value was entered in on the data form. Is there a specific formula/function for this? Perhaps some type of if statement?

[Bryan Hessey]

Is it possible...to have a cell contain a formula in which the value within the cell is automatically something if nothing else was manually entered in that specific cell?

For example, I would want a certain cell to always be "--" if no other value was entered in on the data form. Is there a specific formula/function for this? Perhaps some type of if statement?

Hi,

One way is to type '-- into the cell, then when you type a figure in that will be overwritten.

hth
---

[Freezerburn]

Hi,

One way is to type '-- into the cell, then when you type a figure in that will be overwritten.

hth
---

That is what I currently am doing, but new rows are inserted into the sheet very often so they don't come "pre-loaded" with the double dash in the cell. I don't think what I asked originally is possible. Thanks anyways!

[Bryan Hessey]

That is what I currently am doing, but new rows are inserted into the sheet very often so they don't come "pre-loaded" with the double dash in the cell. I don't think what I asked originally is possible. Thanks anyways!

Hi,

to cover the insertd single row, or inserted multiple rows, and put '-- in column A of such rows, then on the sheet tab, Rightmouse and select View Code, and paste this code into the sheet displayed.

Please Login or Register  to view this content.

If the column is not A, then change the red number to the number that represents the column (do =Column() in a cell of that column to confirm).

Let me know how you go
---