Chris has attended:
Excel Intermediate course
Excel Advanced course
Excel VBA Introduction course
Excel VBA Intermediate course
Custom Cell Formatting
If I enter 10 characters in a cell, which is a mixture of numbers and letters (e.g WE72010000), is it possible, via custom cell formatting, to auto insert dashes after the fourth and sixth character (e.g. WE72-01-0000?
RE: Custom Cell Formatting
Hi Chris,
Thank you for the forum question.
Unfortunately I cannot help you. It is not possible for text to do what you want only for numbers. If it is only numbers the custom formatting should be ????-??-????.
I am sorry it is very rare that something is not possible in Excel.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
