Add asterisk to string with number format

nd0911

Board Regular
Joined
Jan 1, 2014
Messages
115
Hello,

Is it possible to add the asterisk sign to string of text with the custom number format ?

i dont want to concatenate the string with the asterisk just format so in the formula bar the asterisk will not exist.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
8,073
Office Version
2019
Platform
Windows
Assuming that this is to format barcodes, a custom format of \*@\* should do it.
 

Watch MrExcel Video

Forum statistics

Threads
1,090,023
Messages
5,411,886
Members
403,403
Latest member
BBleaz

This Week's Hot Topics

Top