| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
date format...3.1.2010
Hi all
Excamble: In the cell: 3.1.2010, formula bar looks-- 3.1.2010 9:21:48 AM. Cell format is general, why? How I change this to 3.1.2010? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
date format...3.1.2010
Because it is a text string, not a date. You would need to chop the time
element off. -- HTH Bob "backmara" wrote in message ... Hi all Excamble: In the cell: 3.1.2010, formula bar looks-- 3.1.2010 9:21:48 AM. Cell format is general, why? How I change this to 3.1.2010? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date format year to another (e.g., from 1/2/2010 to 1/2/2009) | Excel Discussion (Misc queries) | |||
| how can i get the date & time format 2010/02/17 12:05 in excel | Excel Discussion (Misc queries) | |||
| Auto date in excell 2010 | Excel Discussion (Misc queries) | |||
| 2010 date in Excel 2000 | Excel Discussion (Misc queries) | |||
Linear Mode
