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 • You can use the ExcelFormat function to apply or unapply Text format to a range programmatically. |
