Replacing
Hello,
I am replacing the "."(dots) of a date which comes from the system(
example:28.02.2006) with "/" so that my excel does recognize it as a date.
I used to do manualy until recently. When I tried to automate it with VBA I
saw that it is not recognized as a date. When you select the cell and place
your cursor on the fomula line and hit enter it is recognized.
I tried to record a macro and use the code but it generates a code like this
which is not much use to me I guess(since the dates will change):
ActiveCell.FormulaR1C1 = "2/28/2006"
I know it is probably a stupid question but some hwlp would be greatly
appreciated.
Thanks a lot,
Ozgur
|