Results 1 to 5 of 5

Find/Replace strips out zeros

Threaded View

mhlangensiepen Find/Replace strips out zeros 08-07-2012, 11:06 PM
outofthehat Re: Find/Replace strips out... 08-08-2012, 01:30 AM
mhlangensiepen Re: Find/Replace strips out... 08-08-2012, 02:00 AM
Cutter Re: Find/Replace strips out... 08-08-2012, 09:27 AM
mhlangensiepen Re: Find/Replace strips out... 08-08-2012, 07:51 PM
  1. #1
    Registered User
    Join Date
    11-10-2010
    Location
    Perth
    MS-Off Ver
    Excel 2003
    Posts
    10

    Find/Replace strips out zeros

    Hi,
    I have an Excel 2010 sheet in which I have a columns of part numbers in the form 003.04.010

    I need another column where the period is stripped from this format so that the above part number would become 00304010

    The relevant columns have been specified as text but when I try a find/replace to get rid of the period (find /, replace null) the part number gets the leading zeros stripped out and becomes
    304010

    I have tried all the parameters I can find without any luck. Anybody got any ideas?

    Thanks

    Mike

    EDIT: Problem solved - used OpenOffice to do the find/replacement (which does it correctly - thanks a bunch Microsoft) and saved it back in Excel format.
    Last edited by mhlangensiepen; 08-08-2012 at 12:25 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1