How do I zero fill columns in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to zero fill columns in a spreadsheet for a thrid party vendor to
import into their system. These need to be 'front filled'.
 
using a macro? If so:

Say you want to zero-ed cells A1:B100 and D1:D100 of the active sheet
Dim Rg as range
Set Rg = ActiveSheet.Range("A1:B100,D1:D100").Value = 0

Regards,
Sebastien
 
sorry , i meant:
Dim Rg as range
Set Rg = ActiveSheet.Range("A1:B100,D1:D100")
Rg.Value = 0
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
converting db need six digit w leading zeros, 2
A fixed field format needs fronting zeroes for each cells value. 8
How to count the maximum number flanked by zeros 9
NumberFormat for small non-zero numbers? 2
Series fill only copying and fill series greyed out 1
looking for a function that will populate opening a worksheet or t 2
@average function 2

Back
Top