Automatic insert of forward slash (/)

**Shivas Regal** · 09-08-2010, 03:57 PM

I am constantly typing numbers down columns and am forever having to insert a slash (/) between the numbers.

Is there a way to auto insert a slash (/) where I need it.

Eg: 520101473 needs to be 5/2010/1473

I dont mind making another column which = the desired effect.

Thanks in advance

**shg** · 09-08-2010, 03:59 PM

You can format the column as 0/0000/0000, but values entered that way will be numbers, not text.

**arthurbr** · 09-08-2010, 03:59 PM

Hi
does your number always have 9 digits and will the outcome always be as x/yyyy/zzzz ?

**sweep** · 09-08-2010, 04:00 PM

Hi,

Provided the slash always goes in the same place in a 9 digit number

=LEFT(A1,1)&"/"&MID(A1,2,4)&"/"&RIGHT(A1,4)

**Shivas Regal** · 09-08-2010, 04:08 PM

well the number will always be x/yyyy/zzzz or xx/yyyy/zzzz

xx and x being the current month so 1 - 12

Thanks so far guys

**sweep** · 09-08-2010, 04:11 PM

How about this?

=IF(LEN(A1)=9,LEFT(A1,1)&"/"&MID(A1,2,4)&"/"&RIGHT(A1,4),LEFT(A1,2)&"/"&MID(A1,3,4)&"/"&RIGHT(A1,4))

**Shivas Regal** · 09-08-2010, 04:16 PM

That will do nicely !!!

Thank you very much

**contaminated** · 09-08-2010, 04:27 PM

or without using IF check

=LEFT(A1,LEN(A1)-10+2)&"/"&MID(A1,LEN(A1)-10+3,4)&"/"&RIGHT(A1,4)

**DonkeyOte** · 09-08-2010, 04:27 PM

FWIW you can use shg's approach in a TEXT call

=TEXT(A1,"#0\/0000\/0000")

Automatic insert of forward slash (/)

LinkBack

Thread Tools

Rate This Thread

Display

Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Re: Automatic insert of forward slash (/)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions