Automatically convert inserted value in a cell.

[Ubilen]

Hi,

I am a very basic user in the Excel world. Hopefully learning day to day :) 

I need help with how to automatically convert my inserted value in a cell to another format. 

It is a specific value of input I will use. Actually a tyre size dimension. 

So what I want is... When I manually type in for example the value 2056016 I want this to automatically

convert to show as 205/60R16 in the actual cell. 

Anyone that could help me with a formula or something for this? 

[#2]

Hi @Ubilen,

I would recommend add the new column & paste this formula. Just type number and output will come in result column 

=LEFT(A2,3)&"/"&MID(A2,4,2)&"R"&RIGHT(A2,2)

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com

If you find the above solution resolved your query don't forget mark as Official Answer.

[#3]

If you find the above solution resolved your query don't forget mark as Official Answer.