Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing
Try
ActiveCell.Value = ActiveCell.Value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ozgur Pars" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing
Hi Bob thanks for your reply but it did not work.
Ozgur "Bob Phillips" wrote: Try ActiveCell.Value = ActiveCell.Value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Ozgur Pars" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
replacing 0's | Excel Discussion (Misc queries) | |||
Replacing #N/A | Excel Worksheet Functions | |||
replacing help | Excel Programming | |||
Replacing #N/A with a '0' (zero) | Excel Worksheet Functions | |||
Help Replacing all ( * ) with ( - ) | Excel Discussion (Misc queries) |