Date copy issue in excel
Closed
Naga
-
Jun 13, 2010 at 05:53 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 04:54 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 14, 2010 at 04:54 AM
Related:
- Date copy issue in excel
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel - Guide
- How to take screenshot in excel - Guide
- How to calculate 90 days from date in excel - Guide
- Excel free download - Download - Spreadsheets
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 13, 2010 at 06:13 PM
Jun 13, 2010 at 06:13 PM
Is data in excel ? Could you post a sample book with macro that pulls data from web onto excel
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc and post back here the link
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 13, 2010 at 08:22 PM
Jun 13, 2010 at 08:22 PM
Use this Custom function
To call the function you would say
=convertToDate(a1)
or
=convertToDate("JUN 12,2010 00:31:26")
Function convertToDate(inString As Variant) As Variant
If (inString = "") Then
convertToDate = ""
ElseIf Not IsDate(inString) Then
convertToDate = inString
Else
convertToDate = CDate(inString)
End If
End Function
To call the function you would say
=convertToDate(a1)
or
=convertToDate("JUN 12,2010 00:31:26")
Hi rizvisa1
Its a great idea...Working well.. However i need you to still more fine tune.
I cannot use "=convertToDate(a1)" as I cannot have both the dates in the worksheet.
For ex: JUN 12,2010 14:53:13 date should be present in the worksheet to covert it to 12/06/2010 14:53
neither
I cannot use "=convertToDate("JUN 12,2010 00:31:26")" as I copy and paste from webpage.
not easy to insert for every entry.
Thanks in advance
Its a great idea...Working well.. However i need you to still more fine tune.
I cannot use "=convertToDate(a1)" as I cannot have both the dates in the worksheet.
For ex: JUN 12,2010 14:53:13 date should be present in the worksheet to covert it to 12/06/2010 14:53
neither
I cannot use "=convertToDate("JUN 12,2010 00:31:26")" as I copy and paste from webpage.
not easy to insert for every entry.
Thanks in advance
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 14, 2010 at 04:54 AM
Jun 14, 2010 at 04:54 AM
This is what you do
Insert a new column next to the column that has date
enter the formula in the first cell of the newly added column
select the newly entered column and choose copy
then pastespecial as values
delete the original column
i neglected to mention that you would have to format this newly added column as date in the manner of your choice
Insert a new column next to the column that has date
enter the formula in the first cell of the newly added column
select the newly entered column and choose copy
then pastespecial as values
delete the original column
i neglected to mention that you would have to format this newly added column as date in the manner of your choice
Jun 13, 2010 at 06:15 PM