ExcelBanter - If I have a list of numbers, how do I insert a dash in each one?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If I have a list of numbers, how do I insert a dash in each one? (https://www.excelbanter.com/excel-discussion-misc-queries/248772-if-i-have-list-numbers-how-do-i-insert-dash-each-one.html)

rayofsunshine969

If I have a list of numbers, how do I insert a dash in each one?

If I have a list of numbers, 11 characters long, example: 00229603210, and
for each number I want a dash behind every 2nd, 6th and 9th number,
00-2296-032-10. Is there an easy way to do this?

Gary''s Student

If I have a list of numbers, how do I insert a dash in each one?

Format Cells... Number Custom 00-0000-000-00
--
Gary''s Student - gsnu200908

"rayofsunshine969" wrote:

If I have a list of numbers, 11 characters long, example: 00229603210, and
for each number I want a dash behind every 2nd, 6th and 9th number,
00-2296-032-10. Is there an easy way to do this?

Mike H

If I have a list of numbers, how do I insert a dash in each one?

Hi,

Try this custom format

00-0000-000-00

Mike

"rayofsunshine969" wrote:

If I have a list of numbers, 11 characters long, example: 00229603210, and
for each number I want a dash behind every 2nd, 6th and 9th number,
00-2296-032-10. Is there an easy way to do this?

All times are GMT +1. The time now is 08:26 AM.