Time format 1500 become 15:00
 

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

Thanks for your answer

Time format 1500 become 15:00
 

Oh Yes, thanks so much.

"מיכאל (מיקי) אבידן" wrote:

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


"tran1728" wrote:

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

Thanks for your answer

Time format 1500 become 15:00
 

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


"מיכאל (מיקי) אבידן" wrote:

And using this in an adjacent cell will also allow calculations.
In cell A1 Type: 1234
In Cell B1 type: =TEXT(A1,"00\:00")
Micky


"מיכאל (מיקי) אבידן" wrote:

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


"tran1728" wrote:

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

Thanks for your answer

Time format 1500 become 15:00
 

Try

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

--
Jacob (MVP - Excel)


"tran1728" wrote:

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


"מיכאל (מיקי) אבידן" wrote:

And using this in an adjacent cell will also allow calculations.
In cell A1 Type: 1234
In Cell B1 type: =TEXT(A1,"00\:00")
Micky


"מיכאל (מיקי) אבידן" wrote:

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


"tran1728" wrote:

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

Thanks for your answer

Time format 1500 become 15:00
 

Superbe, thanks.

"Jacob Skaria" wrote:

Try

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

--
Jacob (MVP - Excel)


"tran1728" wrote:

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


"מיכאל (מיקי) אבידן" wrote:

And using this in an adjacent cell will also allow calculations.
In cell A1 Type: 1234
In Cell B1 type: =TEXT(A1,"00\:00")
Micky


"מיכאל (מיקי) אבידן" wrote:

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


"tran1728" wrote:

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

Thanks for your answer