I have a form and want to place * and * at the end of each string typed by the end user.
I.E.) User types INV04492
Excel would place in the cell : *INV04492*
Any recommendations?
Thanks!
I have a form and want to place * and * at the end of each string typed by the end user.
I.E.) User types INV04492
Excel would place in the cell : *INV04492*
Any recommendations?
Thanks!
Select cells you want to format -> Right click -> Format cells -> Custom format -> (write this) "*"@"*"
Never use Merged Cells in Excel
Thanks! That's what I was looking for. Havn't had to use excel much the past two years so i'm a bit rusty. that's the format i needed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks