Format the column as General. Copy an empty cell. Select the column.
Choose Edit/Paste Special, selecting the Values and Add radio buttons.
Click OK.

This coerces "text numbers" to real numbers.


In article ,
lehigh46 wrote:

Is there any way that I can fix this?