Using &" "& in formula
I and trying to combine 2 cells using &" "& option in a formla
For example
=Al&" / "&B1
I am trying to make it look like this: 51/36
The first number is entered in so that's not the problem. The 2nd number is from a formula so my combined cell is looking like this: 51/36.0004
How do I get rid of the .0004??
I tried making the cell only 2 characters. I also tried a custom format of 00/00 but nothing seems to work to get my cell to look like 51/36.
Any help I would be grateful.
James
=Al&" / "&round(B1,0)
=Al&" / "&round(B1,0)
Perfect! Thanks
Perfect! Thanks