1. N

    Stop fractions from showing as lowest common

    How do I stop 6/18 from reducing to 1/3, even though it's formatted to two digits.
  2. P

    paste special (transpose) based on common cell contents

    Hi All, First of all I'd like to apologise if this has been answered elsewhere, i have searched, but haven't been able to find a solution. Some might come close, but I have no VBA experience (yet!), so I'm not sure how to customise previous answers to suit. Anyway, here goes... I have a...

Some videos you may like

This Week's Hot Topics