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/66290-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

thanks

CLR

converting decimals to fractions

=A1&" "&TEXT(B1,"# #/#")

Vaya con Dios,
Chuck, CABGx3

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

thanks

All times are GMT +1. The time now is 08:36 AM.