When a range is formatted as Text, contents of the range are considered to be Mathematica expressions when transferring them using the Clipboard or programmatically in a macro.
Expressions such as 1/2 or -x can only be entered in cells formatted as Text. For more information, see Strings. Notes • The Expression command on the Mathematica Context Menu provides an easy way to apply and unapply Text format to a range and reenter the contents of the range in the new format. The number format of a range can also be changed using Excel's built-in Format  Cells Number tab. |
