Hello Excel masters,
I'm struggling to get a cell content to display correctly using macros. The cell content is =--7-31 and the displayed text is -24. How do I get it to display --7-31? The equal sign in front throws it off. I've tried all the popular string manipulation functions to no avail. Any help is greatly appreciated.
Other examples:
=--7-31 is currently displayed as -24 while I'd like Excel to show --7-31
=--3-29 is currently displayed as -26 while I'd like Excel to show --3-29
=--10-30 is currently displayed as -20 while I'd like Excel to show --10-30
I'm struggling to get a cell content to display correctly using macros. The cell content is =--7-31 and the displayed text is -24. How do I get it to display --7-31? The equal sign in front throws it off. I've tried all the popular string manipulation functions to no avail. Any help is greatly appreciated.
Other examples:
=--7-31 is currently displayed as -24 while I'd like Excel to show --7-31
=--3-29 is currently displayed as -26 while I'd like Excel to show --3-29
=--10-30 is currently displayed as -20 while I'd like Excel to show --10-30