Excel Time Question

[DEWS2031]

Hi I am looking to find out to convert 3.5 into 3½ - I can convert to 3 1/2 but I need to be like this 3½ - Is there a formula or somewhere in number format that will do it. Thank you

 

[Sanjeev1976]

You can try the below formula :

=IF(A1-INT(A1)=0.5,INT(A1)&CHAR(189),IF(A1-INT(A1)=0.25,INT(A1)&CHAR(188),IF(A1-INT(A1)=0.75,INT(A1)&CHAR(190))))

 

[DEWS2031]

You can try the below formula :

=IF(A1-INT(A1)=0.5,INT(A1)&CHAR(189),IF(A1-INT(A1)=0.25,INT(A1)&CHAR(188),IF(A1-INT(A1)=0.75,INT(A1)&CHAR(190))))

Thank you, that does work, I am just getting used to Excel - If I want to change have this automatically change every different decimal to a fraction in this style is that possile

 

[DEWS2031]

Thank you, that does work, I am just getting used to Excel - If I want to change have this automatically change every different decimal to a fraction in this style is that possile

Hello Sir,that is amazing, it works and shows all the decimals as a fraction - the only issue is the whole numbers are showing as false. If that can be fixed then this would be perfect.

 

[Sanjeev1976]

You can use :

=IF(A1-INT(A1)=0.5,INT(A1)&CHAR(189),IF(A1-INT(A1)=0.25,INT(A1)&CHAR(188),IF(A1-INT(A1)=0.75,INT(A1)&CHAR(190),A1)))