Home » Category » Microsoft Excel

Microsoft Excel: Zero's # 2

205| Thu, 22 May 2008 20:49:00 GMT| anonymous| Comments (3)
I had posted before about displaying zero's. I wasn't quite as detaile
as I should've been with what I needed help on.

I have ID numbers that are 9 digits long and need to be in this forman

##-#######

I need this format to transfer into a mail merge word document, so
need the hyphen to show up when merged. I tried doing the first
numbers in one column and the 2nd set in another column so I could ad
the hyphen in the document and one field on one side; vice versa, bu
both columns will have zero's as starting numbers and it seems exce
doesn't like it.

So my question is this:

A) Can you get a way to have the hyphen show on the merged documen
from excel when it is the format that gives the cell the hyphen?

Or

B) Is there some way I can get excel to let me have numbers startin
with one or two zeros?

Thanks for all your help-my brain is FRIED

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

Keywords & Tags: zero, #, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495022/
 
«« Prev - Next »» 3 helpful answers below.
Let me ask you a question: What do your ID numbers look like in Exce
now?

I ask, because if you enter them as 12-3456789, Excel will treat the
as a text entry, and should merge them in that fashion (e.g. 12-000078
should merge just as written).

More info, please
--
swatsp0
----
swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47885

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

As an aside, you could format your ID cells as TEXT before enterin
data. Excel will then keep leading zeros, hyphens, etc.

Good Luc
--
swatsp0
----
swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1510
View this thread: http://www.excelforum.com/showthread.php?threadid=47885

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

Hi Delaina-

In addition to these other fine suggestions, you can also create a custom
format of 00-0000000 (even include it as part of a Style). One advantage
being that the dash need not be typed.

Regards |:>)

"swatsp0p" wrote:

> As an aside, you could format your ID cells as TEXT before entering
> data. Excel will then keep leading zeros, hyphens, etc.
> Good Luck
>
> --
> swatsp0p
>
> ---
> swatsp0p's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15101
> View this thread: http://www.excelforum.com/showthread.php?threadid=478855
>

cybertaz | Thu, 22 May 2008 20:53:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories