| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel automatically changes the formatting of the cell to "Time"
Hello,
I have a long column of numbers [dates in the YY:DD format]. I wanted to replace ":61" to ":59". Even though the cells are initially formatted as Text, as soon as I make the change, Excel changes the formatting to Time, and the cell with the change now has text ":59:00" in it. Is it possible to force Excel to keep the cells formatted as Text? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting Columns in Excel | Excel Discussion (Misc queries) | |||
| Excel conditional formatting error | Excel Discussion (Misc queries) | |||
| How do I automatically send daily email of updated Excel workbook. | Excel Discussion (Misc queries) | |||
| Excel shifts to wrong worksheet automatically | Excel Worksheet Functions | |||
| pasting into an excel template without losing the formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
