I have the following in one cell and I need to format the 3 answers to allow only 1 decmial place and no leading zero’s.
=(E14*J14)&" / "&(60/E14)&" / "&(E14*J14*C14)
The following is how it looks
38.25 / 1.33333333333333 / 566.1
but I need it to Look Like this
38.3 / 1.3 / 566.1
any ideas on how to do it
Thank You advance
Dave C