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

Report •


#1
December 15, 2010 at 05:56:33
Custom Format: 0-0-0-0

MIKE

http://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
Glad I could help.

MIKE

http://www.skeptic.com/


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 step
alinzul@yahoo.com

Report •

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

Please ask you question in a separate thread.

Thanks.

MIKE

http://www.skeptic.com/


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 cells
On the Task Bar
Select "Format"
At the bottom of the pop-up window select "Custom"
In the input box, under the word "Type:"
enter:

0\,0\,0\,0

which will give you 1,2,3,4

The more numbers you want, the more zeros you use:

0\,0\,0\,0\,0\,0\,0\,0

will give you 1,2,3,4,5,6,7,8,9

MIKE

http://www.skeptic.com/


Report •

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

please


Report •

#9
April 29, 2011 at 05:59:00
Just Custom format the other cell.

MIKE

http://www.skeptic.com/


Report •


Ask Question