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,649
Messages
5,335,482
Members
399,018
Latest member
KathyMoUHC

Some videos you may like

This Week's Hot Topics

Top