Date format issue-EXCEL 2007

[Deepak_sap]

Hello Techies,

I cannot type date format as mm/dd/yyyy or convert any other date format to US date format. e.g. if date is dd-mm-yyyy and when I format the cell using option 'English (United States)', still it does not show the date option with / 'HASH', all the formats are with - 'Hyphen' only.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
In all, I don’t see the xx/xx/xxxx date type option, for any location (Format Cell's window) I see the date format with ‘Hyphen’ (xx-xx-xxxx). Also any formula does not work to convert ‘–‘ into ‘/’.<o></o>
I am using Excel-2007.<o></o>
<o></o>
Appreciate your help.<o></o>
<o></o>
Regards,<o></o>
Deepak<o></o>

 

[jingbrown]

can you not right click a cell and then go to formatt cells - date and choose from there. then when you put any dates it will show up the way you selected it in the formatt.

 

[Deepak_sap]

No, when I right click on cell and select option 'Date' on 'Format Cells' it doesnt show me dates with '/', all the dates are coming with '-' option.

 

[Skybluekid]

Does it allow you to choose the custom option so you can apply your own format?