Remove time

How to I remove time from Employee Id column just in one click?
screenshot.png
mustish1Asked:
Who is Participating?
 
ShumsConnect With a Mentor Distinguished Expert - 2017Commented:
Employee ID cannot be in such format. You would have some other format, which is converted to Date/Time format in your working sheet.
1
 
mustish1Author Commented:
Sorry about that.
0
 
ShumsDistinguished Expert - 2017Commented:
Please post your sample/dummy workbook. Screen shot is not enough.

We need to see what format your employ ID is placed in that column.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mustish1Author Commented:
0
 
Roy CoxGroup Finance ManagerCommented:
Maybe Excel has interpreted the entry as Date/Time because of the use of "/". Try formatting as General or add an apostrophe ("'") in front of the entry
1
 
Roy CoxGroup Finance ManagerCommented:
There is no solution offered!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.