Office 2003 Excel rounding issue when combining two numbers 2

[erikhertzel]

I have a columnA and columnB with numbers in those and want to have a comlumnC with the combination of A+B

Column A is 16 digits and B is 6 digits

So, here is what I have

A B C
5511291000000000 230512 5511291000230510

C is almost right but is rounding the last two digits either down or up (so it is rounding the 12 to a 10 in this example).

What I am doing wrong or how can I fix?

 

[AnotherHiggins]

-> Column A is 16 digits

From Excel's help file (search for Excel specifications and limits):
[tt]
Feature Maximum limit
Number 15 digits
precision
[/tt]

Sorry, but Excel can't do what you want it to.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Surely, these are not numbers that you are going to do MATH on, right?

They are just STRINGS of NUMERIC DIGITS; in reality IDENTIFIERS, yes???...
[tt]
A B C
5511291000000000 230512
C1: =left(A1,len(A1)-len(B1))&B1
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[erikhertzel]

Skip, that is great. Thanks. One more question.

I combined two columns into one in a txt delimiter

So I have this
Column A

0047 5547
0049 0934
0050 1565

I just need to get the space out of each one of these in this column and have this:

00475547
00490934
00501565

It's 8 char plus that space. Can I accomplish this as well?

 

[AnotherHiggins]

Sorry. You threw me when you asked for addition.

For your second problem,
[tab]=Substitute(A2, " ", "")
will do it.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

Or, just select the column and Edit > Replace... typing one SPACE into the FIND and NOTHING in the REPLACE.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]