Date

[wei82]

Haf a prob wif date...For example col A1 "1983-04-03". when i write a function ="insert into abc vaules('"&A1&"')" it gives me insert into abc vaules insert into abc vaules(30409). How to solve tis? Anyone knows?

[barrington]

Try this

="insert into abc vaules(' " & YEAR(A1) & "-" & MONTH(A1) & "-" & DAY(A1) & " ' )"

[wei82]

Try this

="insert into abc vaules(' " & YEAR(A1) & "-" & MONTH(A1) & "-" & DAY(A1) & " ' )"

Thks! It's working fine.