I have 16 numbers in a vertical list, which I want to convert to horizontal.

I am using Control+C, selecting an empty cell then using Paste Special, ticking Transpose, then OK.

instead of the expected horizontal list of numbers, all that appears is a list of 0s.

I do not understand why and so need help; please.

FWIW I am using a legacy version of Excel.