ExcelBanter - converting decimals to fractions

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - converting decimals to fractions (https://www.excelbanter.com/excel-discussion-misc-queries/66293-converting-decimals-fractions.html)

jason2444

converting decimals to fractions

A1 width
B1 5 1/4
C1 =a1&" "&b1
showing up as width 5.25
need to show up as width 5 1/4

I have tried formating the cells dosen't work

Kevin Vaughn

converting decimals to fractions

This worked for me when I tried it:

=F61& " " & TEXT(G61, "# ?/4")
--
Kevin Vaughn

"jason2444" wrote:

A1 width
B1 5 1/4
C1 =a1&" "&b1
showing up as width 5.25
need to show up as width 5 1/4

I have tried formating the cells dosen't work

All times are GMT +1. The time now is 09:48 AM.