Excel format conversion
Excellent... Thanks
"Eduardo" wrote:
try this, cell format, custom and enter
000"-"000"-"000
"Aaron H" wrote:
Thanks Eduardo,
What I need is to add the dash every three caracters
Instead of 123456789 I need as a result 123-456-789
"Eduardo" wrote:
Hi,
you can get the numbers but the text, a solution is to use text to columns
and then insert columns everyt three other
"Aaron H" wrote:
Hi guys, is there a way to convert the following
123456789 to 123-456-789
or
abcdefghi to abc-def-ghi
I need to convert a long list of serial numbers so I can look for them, but
doing it one by one will take me an eternity.
Thanks
|