Format Cells - Costum - Keep text when value is empty

[roelandwatteeuw]

Hi

I want to keep the text "Name:" when the cell is empty.

In Format Cells > Costum I write:
"Name:" @

This will return my text with Name: in front of it
BUT when the value is empty, it returns nothing, not even Name:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Entered Value
[/TD]
[TD]Returned value
[/TD]
[/TR]
[TR]
[TD]John Doe
[/TD]
[TD]Name: John Doe
[/TD]
[/TR]
[TR]
[TD][nothing<nothing></nothing>]

[/TD]
[TD]<nothing></nothing>[nothing]

[/TD]
[/TR]
[TR]
[TD][space<space></space>]

[/TD]
[TD]Name:
[/TD]
[/TR]
</tbody>[/TABLE]


How can I fix this and give the value Name: even when the value is empty?

Thanks

 

[roelandwatteeuw]

Fixed if with a macro:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$100" Then


If Range("A100") = "" Then
Range("A100") = " "

End If
End If
End Sub

 

[ISY]

In Format cells
#.##0,00;0;0;"Nome: "@

 

[roelandwatteeuw]

In Format cells
#.##0,00;0;0;"Nome: "@

Didn't work