Microsoft Excel depends on data that’s stored correctly. If you receive text values that should be real numbers, use one of these methods to get you back to the real work.

The Text To Columns tool will “cut” those strings at any delimiter you specify, so you and your users need never again rekey data into separate columns. Tales of Excel-lence ...