User Profile
ameyad09
Copper Contributor
Joined 11 months ago
User Widgets
Recent Discussions
Re: Does Excel consider date column as text if the number of blank values are more than the date values?
Hi,Thank you for checking.However if I delete those values the column B & C data is gone as well which is required. Is there any way to show the column A as Date without having to delete or Find and replace those hyphen values?815Views0likes2CommentsDoes Excel consider date column as text if the number of blank values are more than the date values?
I have a file which has 2 date columns first column has more blank values than date values due to which the entire column is shown as text when I filter on it.I tried using Format cells ,Datevalue,text(Field,'Date Format') and changed column datatype to date but it still keeps showing as text. 2nd Date column has more date values and it shows as Date when filtered on. How can this issue be resolved for the first column without using Find and Replace manually? I have uploaded the file at below link :Excel Link Also,it does not have any viruses .Please take a look.932Views0likes6CommentsRe: Date Field showing as text due to the '-' hyphens present in the field.
Hi,I tried this and it seems to work ,however as this data is exported via ,it will be a manual process. Also, is this true that Excel consider date column as text if the number of blank values are more than the date values? I tried using format cells to show as date but it still shows as Text.560Views0likes1CommentDate Field showing as text due to the '-' hyphens present in the field.
So ,I have a date field in date format (Jan-17) and when I filter on that field it keeps showing Text Filters as below instead of date Requirement is to get Date Filters as below : One thing I noticed is that when I remove the hyphens(-) which are rows without any date ,it then shows as Date . How can I show this column as Date including the hyphen rows as well?693Views0likes5Comments
Recent Blog Articles
No content to show