| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 57007 | 2005-04-21 02:08:00 | Auto Complete in Excel | stevensaaron (6348) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 347138 | 2005-04-21 02:08:00 | When Ever I type a number in an excel cell. e.g 14 it automatically changes it to 14-Jan Can you help |
stevensaaron (6348) | ||
| 347139 | 2005-04-21 02:15:00 | Right click on the column header - Format cells & take your pick of the options. Bye |
Peter H (220) | ||
| 347140 | 2005-04-21 05:35:00 | Yes its the formatting thats the problem. The cell/s in question have a date format. Select Format|Cells|Number tab and change the category type from Date to Number, then choose how many decimals you wish to display. hth |
Parry (5696) | ||
| 1 | |||||