View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default how to add symbol automatically at begining and end

Maybe you could use a custom format of:
"*"General"*";"*"-General"*";"*"General"*";"*"General"*"

positive;negative;0;text





Don wrote:

I'd like to add asterisk mark automatically at begining and end of what I type.
I formatted a cell as custom format with "*"?"*" and typed 123-456-789 but
it won't work. If I just type numbers, for instance, 123, it works. Help


--

Dave Peterson