Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dd/mm/yy if i change to some other format
if i change this format 07/03/2009 to some other format through right click,
and format cells - date - 07-mar-2009 but the change will be happen to this format July/03/009. But i wnt only on this format dd/mm/yy thanks for helping me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
dd/mm/yy if i change to some other format
the day/month order is a windows setting:
Start / Settings / Control Panel / Regional and Language Options, either change your location, or click Customize, and Date "jckumar" wrote: if i change this format 07/03/2009 to some other format through right click, and format cells - date - 07-mar-2009 but the change will be happen to this format July/03/009. But i wnt only on this format dd/mm/yy thanks for helping me. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
dd/mm/yy if i change to some other format
The value in the cell is really July 3, 2009.
You'll have to reenter the value to make it March 7, 2009. Remember that if you're typing the value, you have to match your windows short date format. After you've entered the value, you can reformat the cell the way you like. But I'd use an unambiguous format (just temporarily) to verify that my value was the date I really wanted. I like: mmmm dd, yyyy as that temporary number format. jckumar wrote: if i change this format 07/03/2009 to some other format through right click, and format cells - date - 07-mar-2009 but the change will be happen to this format July/03/009. But i wnt only on this format dd/mm/yy thanks for helping me. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
excel numbers in general format i cant add cant change format | Excel Worksheet Functions | |||
How do i change numbers in text format to number format? | New Users to Excel |