Time format 1500 become 15:00

[tran1728]

Pls help me.
I want to tape 1500 on A1 and A1 edit 15:00

Thanks for your answer

 

[tran1728]

Oh Yes, thanks so much.

Use 'Custom Format': ##\:##
Micky

 

[tran1728]

Dear Micky, thanks again,

I have a other question, si possible for Macro,
The cursor go directy to the last row+1 of column A

thanks for your reply

 

[Jacob Skaria]

Try

Cells(Rows.Count, "A").End(xlUp).offset(1).select

 

[tran1728]

Superbe, thanks.

Try

Cells(Rows.Count, "A").End(xlUp).offset(1).select