Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need help formatting cells
Hi,
I have a cell with a date value. The format displayes is in the following order: 5/16/2005 4:25:32 PM I need to convert this so that the time does'nt show up. In other words I just need to see 5/16/2005. Is there a way I can do this in excel without using VB. Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting on cells with a VLOOKUP formula in them | Excel Discussion (Misc queries) | |||
counting cells with conditional formatting applied | Excel Discussion (Misc queries) | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Cells losing formatting | Excel Discussion (Misc queries) |