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,891
Office Version
2019
Platform
Windows
Assuming that this is to format barcodes, a custom format of \*@\* should do it.
 

Forum statistics

Threads
1,077,784
Messages
5,336,327
Members
399,076
Latest member
vullistax

Some videos you may like

This Week's Hot Topics

Top