| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formatting Question
I have a field in my spreadsheet that is typed in as 6/29/5. How can I change
this to 6/29/2005? |
|
#2
|
|||
|
|||
|
Select the cells, go to FormatCells, click Date in the list of categories &
pick what you want from the choices offered. You should find what you want there. HTH |:) "Metalteck" wrote: I have a field in my spreadsheet that is typed in as 6/29/5. How can I change this to 6/29/2005? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Question | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Cell formatting behaviour question | Excel Discussion (Misc queries) | |||
| Excel Macro Question about Conditional Formatting | New Users to Excel | |||
| conditional formatting question | Excel Worksheet Functions | |||
Linear Mode
