Zero's

  • Thread starter Thread starter Delaina
  • Start date Start date
D

Delaina

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!
 
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.
 
Back
Top