convert numbers to special text

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a long column of cells that each contain a 10 digit
number in number format. I want to convert all of the
numbers in each cell to text format with dashs in between
the numbers, i.e., 1234567890 (number format) to 123-456-
789-0 (text format)without formating each cell
individually.

Can anybody help?

Thanks, Tim
 
Is there any reason it has to be text, you can get that appearance with
custom format?

000-000-000-0

if it has you can just use a help column with this formula (assuming for
simplicity it is column A)

=TEXT(A1,"000-000-000-0")

copy down, copy and paste special as values over the old numbers,
delete the help column
 
Back
Top