"angelgrant" wrote:
I'm sort new to excel and im looking for a formulae to automatically
add a forward slash after every 3rd number and before the 4th number.
One try ..
Assuming numbers in A1 down,
Put in B1:
=IF(LEN(A1)=0,"",IF(LEN(A1)<4,A1,LEFT(A1,3)&"\"&MI D(A1,4,99)))
Copy down
I've assumed that numbers less than 4 digits are to be left untouched
(the "99" in MID is just an arbitrary figure)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---