cell format MID

[assafh21]

Hello there

I have Excel Sheet which look like multiplication table but the number are my catalog numbers available usage (See table below)

I wish to show only the mid numbers (mid 7,3 of the number: 001, 002...) but the full value will stay for other usages

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]21609500000[/TD]
[TD]21609500100[/TD]
[TD]21609500200[/TD]
[TD]21609500300[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]21609501000[/TD]
[TD]21609501100[/TD]
[TD]21609501200[/TD]
[TD]21609501300[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]21609502000[/TD]
[TD]21609502100[/TD]
[TD]21609502200[/TD]
[TD]21609502300[/TD]
[/TR]
</tbody>[/TABLE]

many thanks
Assaf

 

[Oaktree]

I don't believe this is possible with number formats. You'd need to create a separate table with =MID(A1,7,3) copied down and right.

 

[assafh21]

hello there

I know MID function as a formula but I this case I would like to know if I can use MID in other way within cell format
unfortunate I can't use separate table due to other functions which occur on the same cells