Date Format

[smartguy]

Hello all,

Good day. in my macro data extract from some sources.

But the macro extract as #########

i required data format.

Can you please help me.

Sheet1.Cells(I, 8) = vField

 

[smartguy]

Hello all,

Please help...

 

[deletedalien]

Hi there,

we would need more information on your issue to properly assist you with this.

is this the result of a date calculation? if so it seems that this is a negative result (hence the dashes)

also the cell might be formatted as time
Also the cell its self might not be wide enough

HTH