filmov
tv
USE SINGLE QUOTE SYMBOL IN EXCEL | EXCEL TIPS & TRICKS | EXCEL MAGIC TRICKS | USE SINGLE QUOTE SIGN
Показать описание
Excel magic tips & tricks
Excel magic
Use single quote symbol in excel
A single quote ( ' ) in excel is used to maintain formatting of the data enter in the field. Or better yet, to ignore formatting and read it as text. For example, if you want to enter ( +91 ), excel will assume you are trying to enter a formula and will return an error.
Excel magic
Use single quote symbol in excel
A single quote ( ' ) in excel is used to maintain formatting of the data enter in the field. Or better yet, to ignore formatting and read it as text. For example, if you want to enter ( +91 ), excel will assume you are trying to enter a formula and will return an error.