Date formula

[traceyghudson]

I have the following date in format 8/07/2011 and i need to convert it to 08-07-2011 does anyone know what formula I use in an excell spreadsheet?

 

[VoG]

Try

=TEXT(A1,"dd-mm-yyyy")

 

[Andrew Poulsom]

Can't you just right click, choose Format Cells, select Custom on the Number tab and change the format in the Type box (replacing / with -)?

 

[Arul.rajesh]

Select the cells you want to change the format for.

Press CTRL+1

In the format cells dialog box>number tab category: Select custom(the last option on the list), In the type:
enter

m-d-yyyy
hit okay

 

[machopicho]

On cell--> click right button -->in Number choose Personalized --> choose dd/mm/yyyy and in type write dd-mm-yyyy. Press ok!
Bye

 

[traceyghudson]

thanks guys but it won't budge. I highlight the cell and have done the formula and the custom one and it does not move but stay's the same. Is there something wrong with the dates? they are all in this format 9/12/2011
Tracey

 

[barry houdini]

looks like they are formatted as text - if you have a column of those to convert try using "Text to columns"

Select column of dates then

Data > Text to columns > Finish

Now they should be "real" dates that you can format any way you want