Results 1 to 3 of 3

Keeping Leading Zeroes

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2007
    Posts
    14

    Keeping Leading Zeroes

    Usual apologies if this is dumb q, I am not a power user, Excel is simply a means to an end for me!

    OK.... Column A contains product codes. These are of the format: 123/1234, i.e. 3 digits, a slash, 4 digits

    In order to get records into my database, I need to remove the slash, so there are just 7 digits (the match field is structured this way in the database). Unfortunately, some product codes have leading zeros, e.g. 058/1234. Even if I format the cells as 'text', removing the slash changes the cell content to '581234'. How can I make it still say '0581234'?

    I just noticed that if I delete an individual slash manually, the zeroes are retained. How can I make it behave like this for a whole column at a time?

    Thanks!
    Last edited by EmmaG1959; 04-09-2008 at 04:48 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