Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data format
How do I keep a date in the format Sep 08 (for september 2008)? Excel keeps
changing it to 01/09/2008. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
data format
Format to mmm yy
Or enter as text 'Sep 08 Note the apostrophe. Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 16:37:00 -0800, ec17 wrote: How do I keep a date in the format Sep 08 (for september 2008)? Excel keeps changing it to 01/09/2008. |
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 | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel |