=LEFT(C1,5)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"klafert" wrote in message
...
I used it before and cant remeber the function command that will allow me
to
copy just the 1st 5 numbers in a cell to another cell. Thes cells are
like C
& D.

Thanks for your help. Command just slipping my mind.