| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Format
Hello,
I would like help changing the following from: 2005-01-02 11:19:44 to the date only. I know I can reformat the cell; however when I pivot off the formatted cell the cell still shows the time. Your help is appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
On Fri, 10 Mar 2006 07:56:28 -0800, JR wrote:
Hello, I would like help changing the following from: 2005-01-02 11:19:44 to the date only. I know I can reformat the cell; however when I pivot off the formatted cell the cell still shows the time. Your help is appreciated. Thanks =INT(A1) --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Format
JR
=TEXT(A1,"mm/dd/yy") Beege "JR" wrote in message ... Hello, I would like help changing the following from: 2005-01-02 11:19:44 to the date only. I know I can reformat the cell; however when I pivot off the formatted cell the cell still shows the time. Your help is appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell date format doesnt change | Excel Worksheet Functions | |||
| Enforcing a date format on a cell/column | Excel Discussion (Misc queries) | |||
| Change general format to US date format | Excel Discussion (Misc queries) | |||
| Customized Date Format | Excel Worksheet Functions | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
Linear Mode
