Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If (starts with ', then delete the ')
Gentlemen (and Ladies),
Unfortunately the last person who did this job entered dates with a "'" in front of all of them, and excel will not recognize them as dates. I'm looking for some code that will do the following: rownum = 7 Do if Range("P" & rownum).Value [begins with "'"] then [delete the "'"] rownum = rownum + 1 Does anybody know how to do something like this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel E-2007 starts, but Installer also starts 3 times??? | Setting up and Configuration of Excel | |||
Excel Starts When I hit te Zero Key | Excel Discussion (Misc queries) | |||
Zero starts of a number | Excel Worksheet Functions | |||
Delete row if cell starts with ........... | New Users to Excel | |||
formula starts : =+ what does plus indicate? | Excel Worksheet Functions |