| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Autoformatting?
How can I keep excel from changing cell-entered numbers, 04-9215 for example,
into dates? I've tried selecting "none" for autoformatting on entire worksheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autoformatting?
Try General or Text for the Cell Format
jonpoe wrote: How can I keep excel from changing cell-entered numbers, 04-9215 for example, into dates? I've tried selecting "none" for autoformatting on entire worksheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Autoformatting?
Yeah, I should have said I also tried "General" to no luck. "Text" fixed the
problem. Thank you. " wrote: Try General or Text for the Cell Format jonpoe wrote: How can I keep excel from changing cell-entered numbers, 04-9215 for example, into dates? I've tried selecting "none" for autoformatting on entire worksheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limited autoformatting when pasting | Excel Discussion (Misc queries) | |||
| Problems with autoformatting revisited | Excel Discussion (Misc queries) | |||
| Autoformatting of cells in csv files on opening. | Excel Discussion (Misc queries) | |||
| How do I stop Excel 2002 from autoformatting numbers into dates? | Excel Discussion (Misc queries) | |||
| autoformatting issues in excel | Excel Discussion (Misc queries) | |||
Linear Mode
