Keep the starting 0’s

Topic

New Reply

Hi I have a database A1=00 A2=66 A3=08– what I need it to look like is 00-66-08 or 006608 with the 0 before the 0 in A1 and the 0 before the 8 in A3. How, How, How can this be done????

Reply | Quote

Replies

Buckshot,

You need to create a custom format using the number of leading zeros you want. see attached graphic. :cheers:

May the Forces of good computing be with you!

RG

PowerShell & VBA Rule!
Computer Specs

Reply | Quote

If you want to join them in another cell:
=text(A1,”00″)&TEXT(A2,”00″)&TEXT(A3,”00″)
for example.

Reply | Quote