CHANGE DATES

M

ME

I WANT TO BE ABLE TO TYPE 6 DIGIT NO. EG 010101 AND EXCEL CHANGE IT TO 01/01/01 HOW CAN I DO THIS SIMPLY THANKYOU
 
F

Frank Kabel

See your response in Excel.misc newsgroup. And in addition to not using
Caps lock, please don't multipost
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount -Date Criteria - Won´t find it - 0
How to add day to PWA 2016 date format? 0
Which Function to be used?? 2
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Set date minuse 1 working day 3
Sorting 1
Excel date formate doesn't change 0
CHANGE DATES 1

Top