Hi,
I am trying to have a specific format for a cell that i need some help with:
the value of A3 = A1&" / "&A2 --> to give 3 / 3 for example - thats fine
but the formatting of A1 and A2 are such that when 3 is entered it displays 3.0kg (due to 0.0"kg" as format)
so now, how do i get the format of A3 to show 3.0kg / 3.0kg??
Thanks
Kyle
Bookmarks