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:

Entered Value	Returned value
John Doe	Name: John Doe
[nothing<nothing></nothing>]	<nothing></nothing>[nothing]
[space<space></space>]	Name:

<tbody>
</tbody>

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