Format

[MCT87]

I've got a lot of data to enter an it's all in a format like 01-01-0, 04-05-4, etc... (stock locations). It would be a lot quicker if I could just type 01010 or 04054 and excel would put in the - for me. Is there a custom format that could help me achieve this?

Any help really appreciated.

 

[arthurbr]

Perhaps 00-00-0

 

[JoeMo]

Format the cells (Custom): 00-00-0

 

[MCT87]

Format the cells (Custom): 00-00-0
View attachment 23922

Thanks JoeMo that's done it =)

I appreciate your help, it's going to save me a lot of time!

All the best for the weekend.

 

[JoeMo]

Thanks JoeMo that's done it =)

I appreciate your help, it's going to save me a lot of time!

All the best for the weekend.

You are welcome - thanks for the reply.