View Single Post
  #2   Report Post  
R D S
 
Posts: n/a
Default

="*"&A1&"*"

seems to work after some trial and error,
could there arise a problem doing it this way?

Thanks,
Rick

"R D S" wrote in message
...
Hi,
A simple one im sure, cell b4 contains a number, i want cell c4 to display
the same number with an asterix (asterisk?) at either side for my bar code
font?
="*",B4,"*"
What's the correct way to enter this?

Many thanks as ever,
Rick