Tags: PASTE SPECIAL

Convert multiple columns of numbers into text at once

{ 4 Comments }

Assume numbers in range C10:C13 as 12,23,34,45.  Assume numbers in range E10:E13 as 56,67,78,89.  For uploading these two columns (along with other columns as well) into an ERP, C10:C13 and E10:E13 need to be converted to text values i.e. numbers stored as text values. Once way to do this is to: 1. Select C10:C13 and to go Data […]

Read More →