Keep Text Value but show other thing

[Unexpc]

Hi guys
any formula that can Keep a text value but show another thing?
for example i write New Customer in a cell, but show hinzufügen?
it means excel find out this cell fill with New Customer but show hinzufügen
this question i asked for not another language symbol in vba code, and i want the formula for this cause

 

[Joe4]

An Excel formula can either contain a formula OR a hard-coded value, but never both at the same time.
Numeric entries can be formatted to display differently than entered (i.e. think of dates).
But I don't know of any way to display a text value differently than entered, while still maintaining the original text entered.
You could use VBA code to automatically convert entries to something else, but then it would be changed and not maintain the original text entered.

 

[jasonb75]

You could apply conditional formatting with a rule like

=A1="New Customer"

That applies a custom number format of

;;;"hinzufügen"

 

[Unexpc]

You could apply conditional formatting with a rule like

=A1="New Customer"

That applies a custom number format of

;;;"hinzufügen"

Awesome, This is correct, Thank You