Cell Format

F

frustratedwthis

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!!
 
D

Dave F

Use the formula =LEFT(B2,4) and fill down in the No. column. This assumes
that BU# is in column B; adjust to suit your needs.

Dave
 
J

JMay

=--LEFT(B2,4)

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

frustratedwthis

Thank you.. That works beautifully :)

Dave F said:
Use the formula =LEFT(B2,4) and fill down in the No. column. This assumes
that BU# is in column B; adjust to suit your needs.

Dave
Click to expand...
 
Top