=(A1&B1&C1)*1


Gord Dibben MS Excel MVP

On Thu, 26 Mar 2009 11:50:01 -0700, Mac8128
wrote:

How can I concatenate three cells each with a number so that the concatenated
cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133