combine cells and maintain significant digits

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ian - 04 Jan 2007 02:51 GMT

I'm trying to join 3 cells that are map references
A1 35
B1 02
C1 105

When I join the with A1&B1&C1 I get 352105 when I need 3502105. How do I
maintain the significant digits to the left without changing the cells to
text format? (I'd like to maintain them as numbers for other reasons).

Thanks.

Reply to this Message

Ron Rosenfeld - 04 Jan 2007 03:14 GMT

>I'm trying to join 3 cells that are map references
>A1 35
[quoted text clipped - 6 lines]
>
>Thanks.

=TEXT(A1,"00")&TEXT(B1,"00")&TEXT(C1,"000")

--ron

Reply to this Message

Rate this thread: