This line changes the formula to a value I need for subsequent operations, however it changes a fraction 1/8 to a date of 8-Jan. I need it to remain 1/8.
[vba]
.Range("M4:M" & LRowV).Formula = .Range("M4:M" & LRowV).Value
[/vba]
Hopefully a simple fix...
Thanks.... (sorry for hitting the board so much, trying to finish this one piece)