| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing the date format in a cell
I have generated an Excel file from one of our applications, and it has a
field for a date with a format of 9-2006. I need to put a leading zero in front of the month so it sorts correctly. Is there an easy way to do this? I tried to set a custom format to it. It doesnt seem to take until I click off of it and back on it, then it updates it and works. i have to do it to 8,000 rows and it would take forever. TIA Scott T. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the date format in a cell
Is your sheet set to "Manual Calculation"? Click ToolsOptions | Calculations and make sure "Automatic" is checked. Set your format and all should update at the same time. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=570104 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Changing the date format in a cell
It was already set to automatic.
"swatsp0p" wrote: Is your sheet set to "Manual Calculation"? Click ToolsOptions | Calculations and make sure "Automatic" is checked. Set your format and all should update at the same time. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=570104 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| date format within a cell containing a formula | Excel Discussion (Misc queries) | |||
| problem with formatting cell to date format | Excel Worksheet Functions | |||
Linear Mode
