How do you CONCATENATE with numbers

[umpie]

Help

we know that when we use the CONCATENATE function this combines two
peices of text, however if we want to do this with numbers and have
them remain formatted as numbers what formula do we use?

Thanks for your help

 

[Frank Isaacs]

=VALUE(CONCATENATE(12,15))

--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com

 

[Harlan Grove]

=VALUE(CONCATENATE(12,15))

...

Of eliminate function calls altogether: =--(12&15)

 

[Frank Isaacs]

Nice trick with the double minus!
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com