View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin Barrios Kevin Barrios is offline
external usenet poster
 
Posts: 1
Default "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!