Copy a blank cell highlight your range right click Paste Special Add OK


"juanpablo" wrote:

Hi,

Sometimes, when I import databases, the numbers are not recognized and I
have to manually convert to number, using the 'autocorrect' tab by each one.
Is there a faster way to change them all at once?

Thanks

JP