Sure,the VBA version is DATEVALUE()the string must be in a valid date format
for your Windows version.
So, if when you enter a date in Excel, it is displayed as mm/dd/
format,then you need to "build" a string in this format.
like:Sub MakeDate()
Dim nRow
For nRow = 1 To 30
If (
Thanks for you're reply and it's working.
There is any way to do this via VBA for all cells in a columns.
Thanks, Krishnasamy.M.
On Jun 17, 2016 8:48 PM, "Paul Schreiner" wrote:
> Do you know if the cells contain actual DATES or if they are text strings?
>
> To check: try changing cell format t
Do you know if the cells contain actual DATES or if they are text strings?
To check: try changing cell format to short date, or General.if they look
different, then they are true "dates" and you simply have to change the date
format to what you want to see.
If they are NOT dates, then you need t
Hi Experts,
I have workbook with approx 300 rows.In this work book column A:A contain
date with "dd.mm." format.
Need to change this on
"dd-mm-yy" Number format.
Thank you for advance.
Thanks,
Krishnasamy.M
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIM
