Add asterisk to string with number format

nd0911

Board Regular
Joined
Jan 1, 2014
Messages
114
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.
 

jasonb75

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

Forum statistics

Threads
1,077,617
Messages
5,335,261
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top