| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
January 08 is abbrecviated to 8-Jan. Help!
I am typing in January 08 in Excel in A1. When I get ready to go to the next
one it is changed to 8-Jan. I do not want 8-Jan. How do I change this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
January 08 is abbrecviated to 8-Jan. Help!
djb877
FormatCellsNumbers TabSelect "DATE" and choose what you like from the options. "djb877" wrote: I am typing in January 08 in Excel in A1. When I get ready to go to the next one it is changed to 8-Jan. I do not want 8-Jan. How do I change this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
January 08 is abbrecviated to 8-Jan. Help!
Type 1/1/08. If you enter a date with only two parameters, Excel assumes
you've entered month and day, and uses the current year, hence January 08 becomes January 8, 2008. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "djb877" wrote in message ... I am typing in January 08 in Excel in A1. When I get ready to go to the next one it is changed to 8-Jan. I do not want 8-Jan. How do I change this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning value if month is January | Excel Worksheet Functions | |||
| Return day of week for 1 January | Excel Worksheet Functions | |||
| Return the day of week for 1 January | About this forum | |||
| January 2006 | Excel Discussion (Misc queries) | |||
| error with smproduct for January | Excel Discussion (Misc queries) | |||
Linear Mode
