EXCEL Issue : In excel, date field is coming as numeric value when changing in to text format. For this do the below steps: 1) change the date column field in to text format. 2) Now it becomes numeric values. 3) Delete the field data (numeric values) 4) Copy the actual required date format (2009-02-25) in to notepad 5) Copy it again and past it in the excel where numeric fields were deleted. 6) Now date will be in text format and un editable.
Posts
Showing posts from December, 2022