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
 
Back
Top