Code to format data in cells in VB

  • Thread starter Thread starter vhung
  • Start date Start date
V

vhung

I have some data in a table access which have some fields writed in 00X
format (X is a number) and I want to write a function to write those
fields to cells in a sheet in Excel in 00X format (0 is number 0). But
I don't know code to write. Who can help me.
Thank you very much
(Canh thiu thi nhau muc)
 
One option:
Let Excel handle the numbers for you and give the column a custom number
format of 000
 
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

Border formatting row of cells 22
Excel is changing date format incorrectly 7
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Formatting values populated by VB Code 3
Apply cell formatting using VBA 1
VB code to concatenate 100+ cells 3
Excel VB to capture the current cells row number 4
I need to use the last row of data in a formula 3

Back
Top