View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default formulae for adding a forward slash automatically into a cell

"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
---