Custom Format with slashes between number

[howard]

I have a number 19920195872597


I need a to format this as 1992/01958725/97


It would be appreciated if someone could assist me using a custom format

 

[Joe4]

Assuming all your entries are the same length, this Custom Format should work:

000\/00000000\/00

 

[jim may]

It's funny how that there are 14 characters in the 19920195872597
and there are ONLY 13 characters in your Custom Format;
Further the format seems to set out ONLY 3 characters before the "\ /"
So where's the logic in this? It works fine!!

Tks -- Jim

 

[Joe4]

That was a typo, I meant to type:

0000\/00000000\/00

However, it is formatting from the right to left, just like if you did a number and wanted to custom format where to place the commas for the thousands places.
So you could actually use this and it would still work:

0\/00000000\/00

Just as long as you have at least one zero before the first slash.

 

[Gerald Higgins]

jim may - good question.

I experimented with variations on Joe4's suggestion - these all give the same result, at least for the given input value

0\/00000000\/00
00\/00000000\/00
0000\/00000000\/00

I think this gives a clue as to how Excel is working this out - it's reading from the right and inserting a "/" before the last two characters, and so on.

This variation
00000\/00000000\/00
gives this result
01992/01958725/97
in other words padding with zeroes.

Edit to add - Oops - too slow !

 

[jim may]

Thanks Joe. Good to know...

 

[jim may]

Thanks Gerald. Good to know...

 

[howard]

thanks Joe & Gerald


Your custom formatting works perfectly