Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to keep away from converting a cell into date format. when is a date enter the cell converted into date format even if a number is entered?

user-image
Question added by Shahzad Sayeed
Date Posted: 2017/10/07
Firas Shahadi
by Firas Shahadi , Human Resources Director , SAUDI UNION

you need sometimes to remove all the format applied then start from the beginning.

Syed Amjad Abid
by Syed Amjad Abid , Admin , Al Mana Fashion Group (Sports

simply select that cell as a text.

Mohammed Mokbel
by Mohammed Mokbel , Production Manager , Madar Group JO for detergent

you can change the format of that cell before you type any information in it, or you can seperate the information inside the cell using the Dot (.) mark

More Questions Like This