Home » Category » Microsoft Excel

Microsoft Excel: Zero's

205| Thu, 22 May 2008 20:50:00 GMT| anonymous| Comments (2)
I am doing a report where 0 is the first number in the cell, but not for
every cell. So they look like this:

094521463
456245654
654621327

When I try to format it to put a hyphen between the 2 and 3rd numbers
the 0 erases.

Is there a formula that would allow me to change all the 9 digit
numbers I have to put the hyphen in?

I want...

094521463 09-4521463
456245654 to look like: 45-6245654
654621327 65-4621327

so when I mail merge the hyphen will show as well.

Thanks for the help!

--
Delaina
---
Delaina's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24151
View this thread: http://www.excelforum.com/showthread.php?threadid=477952

Keywords & Tags: zero, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495021/
 
«« Prev - Next »» 2 helpful answers below.
Sounds like these are not numbers that you will do any math operations
on so you can treat them as text. Select all the cells and
Format>Cell>Text. You may have to go back and add the 0 at the front.
You can use ASAP Utilities to add the zero to all the cells at once.
See 'Asap Utilities' (http://www.asap-utilities.com/) . Asap Utilities
is a free Excel Add-In.
neopolitan

---
neopolitan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=611
View this thread: http://www.excelforum.com/showthread.php?threadid=477952

neopolitan | Thu, 22 May 2008 20:51:00 GMT |

Hello Delaina,

Use a Custom Format ...

00"-"0000000

HTH
--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)

"Delaina" <Delaina.1x7n6b_1129827910.9815...excelforum-nospam.com> wrote in
message news:Delaina.1x7n6b_1129827910.9815...excelforum-nospam.com...
> I am doing a report where 0 is the first number in the cell, but not for
> every cell. So they look like this:
> 094521463
> 456245654
> 654621327
> When I try to format it to put a hyphen between the 2 and 3rd numbers
> the 0 erases.
> Is there a formula that would allow me to change all the 9 digit
> numbers I have to put the hyphen in?
> I want...
> 094521463 09-4521463
> 456245654 to look like: 45-6245654
> 654621327 65-4621327
> so when I mail merge the hyphen will show as well.
> Thanks for the help!
>
> --
> Delaina
> ---
> Delaina's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=24151
> View this thread: http://www.excelforum.com/showthread.php?threadid=477952
>

zack | Thu, 22 May 2008 20:52:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories