View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ledge Ledge is offline
external usenet poster
 
Posts: 13
Default Combine 2 columns of numbers (A+B=C)

This has me totally stumped......

Is it possible to combine column A with column B to get this result?

Column A Column B Column C
8888021100013 00020 888802110001300020
9310004342206 00003 931000434220600003

I can combine the A&B ok but I keep losing the zeros in column B and my
result looks like this:

Column A Column B Column C
8888021100013 00020 888802110001320
9310004342206 00003 93100043422063

The string in column B must be 5 numbers and I have tried many
differing formatting options but just cant seem to get the wanted
result.

Would really appreciate if someone could point me in the right
direction.

Regards,
Dean