?
Solved

leading 0's stripped

Posted on 2014-02-17
3
Medium Priority
?
168 Views
Last Modified: 2014-02-17
Is there any way to add back into a column leading 0's that have been stripped during an extract. Basically we have a column, all should be in a 8 character numerical sequence. However those beginning with 0's have been stripped down to 7 characters. How could I reformat those (i.e. if 7 characters long add a leading 0).
0
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 8

Assisted Solution

by:Naresh Patel
Naresh Patel earned 668 total points
ID: 39864584
try this
=IF(LEN(A1)=7,"0"&A1,A1)

Open in new window


Thanks
0
 
LVL 70

Accepted Solution

by:
KCTS earned 668 total points
ID: 39864602
Select Format-Cells-Custom and type 00000000
0
 
LVL 24

Assisted Solution

by:Steve
Steve earned 664 total points
ID: 39864607
Try:

=TEXT(A1,"00000000")

Then copy down the rows.
Then copy and paste special values back over the original range.

Or
format the range using a custom format of "00000000"
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question