Thank you!! This works beautifully as well!! :)

"JMay" wrote:

=--LEFT(B2,4)

Left() retutns a string - but the "--" converts it back to a number.
HTH


"frustratedwthis" wrote:

This is probably an easy one...and I'm sorry :)
No. BU # Amt.
? 21000 $15.00

I would like to format the no column to only bring over the first 4 numbers
from the BU column...
Is this possible?

Thanks in advance!!