Rich needs to VLOOKUP into data with ” Total” after the tracking number.

When he tries to Replace ” Total” with “”, Excel converts the tracking numbers to scientific notation. When he tries to convert everything to numbers and I lose the last several digits when they change to 0000.

In today’s video, a new option in Microsoft 365 beta to prevent the conversion to scientific notation. And then a way to hack the VLOOKUP formula.

Table of Contents
(0:00) Copy subtotals in Excel
(0:36) Replace in Excel converts to Scientific Notation
(0:54) Long numbers in Excel last digits change to zero
(1:09) Beta option to prevent Data Conversions in Excel
(1:49) Hacking VLOOKUP to add Total for subtotal rows