Question: I have a question about how can I validate a required change at rails model.

for example:

to the param lock\_version we need the validate if this value always is present when tried to update the model.

has rails some validation to test the change presence?

Thanks

Answer: 
Is an issue quite old, but the solution that works only takes 1 line:
Put these before saving, on the column you need.

> 
> Columns("D:D").NumberFormat = "dd/mm/yyyy"
> 
> 
> 

It really worked for me.
Regards
I'm just guessing if I could help... 

```
Sub SaveSheetsAsText()

Dim sFile As String
Dim sht As Worksheet

For Each sht In Worksheets

'myImplementation
    Dim rng As Range 'always is better to set te var in the beginning
    Dim r
    Dim c
    Dim i
    Dim t

    r = Range("A1").End(xlDown).Row 'take the row of the last cell in column A
    c = 1 'Column A 'Just take the number of the column

    Set rng = Range(Cells(1, 1), Cells(r, c)) 'Set the range with the dates

    For Each i In rng 'for each date in the range
        t = i.Text 'Store the TEXT (not the date) inside the var
        i.NumberFormat = "@" 'Set the format of the cell to Text
        i.Value = t 'set the value of the cell to the text of the date
    Next i 'next one please!
'myImplementation

    sht.Copy
    sFile = sht.Name & ".txt"
    ActiveWorkbook.SaveAs Filename:=sFile, FileFormat:=xlText, CreateBackup:=False, Local:=True
    ActiveWorkbook.Close SaveChanges:=True
Next sht

End Sub

```

As i told you in the comment: if you got a date in the cell, when you see the formula bar you see the unformat date (the raw content: `1/19/2016 9:00:00 AM`) but in the cell you format that content as a date, number or anything else. If you see in the cell this `08:23 21/01/2016` as in the formula bar, you don't have a date you have a text inside de cell. 

Your code goes to every sheet, but before save anything, change the date to a text... this works for me, but please tell me if this not work to impove it.