Excel, remove leading apostrophe 4 WAYS! Microsoft Forms, formats numbers as text.

Описание к видео Excel, remove leading apostrophe 4 WAYS! Microsoft Forms, formats numbers as text.

Microsoft Forms exported results formats numbers as text by adding a leading apostrophe Infront of all numbers. In this tutorial you will learn 4 easy ways to remove the leading apostrophe from all numbers and have Excel auto recalculate functions.
0:00 Intro on How Microsft Forms exports numbers with apostrophe
04:05 Method 1 (Clear Formats)
06:14 Method 2 (Paste Values)
07:37 Method 3 (Text to Columns)
09:48 Method 4 (Paste Special) this is my preffered method

Комментарии

Информация по комментариям в разработке

Похожие видео