"Replace all" changes formatting
Yes, Excel is a great document tool but it has its limitations as well. The
zeros before a number value has always been a little fussy. For example, zip
codes on the east coast.
In order to preserve your data with minimizing re-typing in numerous fields,
this is the "work around". There may be a more elegant solution, but this is
the only way I know how to get what you want done, done.
1. Your MAS-500 is most likely outputting the file to a .txt or .csv or some
other simple text file. Open up that file, select everything and then just
put it in a Word document (use paste special, unformatted text)
2. In Word, do the find/replace and replace the SO- with "nothing"
3. Copy all of the data onto the clipboard
4. Open up an Excel file and format a column to "text"
5. Use Paste Special, Text, and copy into the column.
------------------
Text formatting is one of the most common ways to preserve zeros before a
number. However, this will have limitations as it is a text value and not a
numeric value. In order to preserve a numeric value with zeros in front,
another option is to use the "custom" format and just put in 10 0's in your
case.
Hope this helps, cheers!
|