converting decimals to fractions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

converting decimals to fractions 1
converting decimals to fractions 5
Splitting Numbers into Columns. 3
UDF's 5
Multiple Range Lookup Possible??? (Expert Level Question?) 3
Decimal Place goes crazy when using the "&" Sign. 4
copy and paste the cell with formula ="1" 3
Converting dd:hh:mm to [h]:mm not working. 3

Back
Top