# In excel, how can I convert 1234 to 1-2-3-4

Microsoft Microsoft office excel 2007 ac...
December 15, 2010 at 03:21:13
Specs: Macintosh
 In excel, how can I convert 1234 to 1-2-3-4

See More: In excel, how can I convert 1234 to 1-2-3-4

#1
December 15, 2010 at 05:56:33
 Custom Format: 0-0-0-0MIKEhttp://www.skeptic.com/

Report •

#2
December 15, 2010 at 12:16:21
 Thank you so much mmcconaghy. I spent 2 hours trying to work out a formula but you made it much easier for me through Custom Format. Thanks again.

Report •

#3
December 15, 2010 at 12:48:23

Report •

Related Solutions

#4
April 26, 2011 at 03:03:11
 In excel, how can I convert 1234 to 1,2,3,4 and 1 2 3 4 Please tell me step by stepalinzul@yahoo.com

Report •

#5
April 26, 2011 at 12:28:37

Report •

#6
April 26, 2011 at 22:26:42
 Mike How can i seperate with you?Please send me reply by email

Report •

#7
April 27, 2011 at 07:11:56
 Alinzul,It is considered impolite to hijack another persons question, next time, just create a whole new thread.With a new thread more people will look at it, otherwise lots of people will not see your question because it's at the bottom of another persons thread.To answer your question use Custom Formatting.Select the cell or range of cellsOn the Task BarSelect "Format"At the bottom of the pop-up window select "Custom"In the input box, under the word "Type:"enter:0\,0\,0\,0which will give you 1,2,3,4 The more numbers you want, the more zeros you use:0\,0\,0\,0\,0\,0\,0\,0will give you 1,2,3,4,5,6,7,8,9MIKEhttp://www.skeptic.com/

Report •

#8
April 28, 2011 at 21:00:45
 hi MIKEthank you. but i need to x number is writing to another cell . for example: if A1=2564 B1=2,5,6,4please

Report •

#9
April 29, 2011 at 05:59:00
 Just Custom format the other cell.MIKEhttp://www.skeptic.com/

Report •