在公式中使用时，excel会将我的日期自定义格式化为数字

I am using a formula to create a series of insert statements to use in SQL. However, when I do this, dates that are part of the spreadsheet (which are formatted dd-mmm-yy and needs to be like this) are changed to numbers when I use a formula. Sorry, tried to explain this the best I could, anyone know a way around this?I am using a formula to create a series of inse