how to clear apostrophes from ranges in excel worksheets

To clear the cells, I clicked the area between cell A, and 1 to highlight all of the cells. Afterwards, I went to Home–>Clear—>Clear format to remove the apostrophe.

 To edit/fix the cells, I selected the last group,i.e. BX to highlight all of the cells in that column. Then, I dragged the arrow to the left to get all of the other cells highlighted. Afterwards, I clicked the error button to convert the text to numbers.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s