Excel 2007 AutoCorrect/Format - Date

[Guest]

When cutting and pasting data, is there a way to turn off Excel's (annoying)
habit of automatically converting a cell defined as "Text" to a "Date"
format? For example:

1. Create a new worksheet
2. Right click on a cell
3. Format cell as 'Text'
4. Enter the following: 2-2-2
5. Find (CTRL + F)
6. Click the Replace tab
7. Find what: 2-2-2
8. Replace with: 2-3-2
9. Click 'Replace All'

Notice how excel has convert the cell from 'Text' to a 'Date' format. I need
the cell to show the 2-3-2 *exactly* as typed. I tried clicking 'Advanced'
option and modifying the cell format, but it still makes some strange
modification to the 2-3-2.

Any ideas?

 

[Matti Ponkamo]

When cutting and pasting data, is there a way to turn off Excel's (annoying)
habit of automatically converting a cell defined as "Text" to a "Date"
format? For example:

1. Create a new worksheet
2. Right click on a cell
3. Format cell as 'Text'
4. Enter the following: 2-2-2
5. Find (CTRL + F)
6. Click the Replace tab
7. Find what: 2-2-2
8. Replace with: 2-3-2
9. Click 'Replace All'

Notice how excel has convert the cell from 'Text' to a 'Date' format. I need
the cell to show the 2-3-2 *exactly* as typed. I tried clicking 'Advanced'
option and modifying the cell format, but it still makes some strange
modification to the 2-3-2.

Any ideas?

Seems like Excel is trying to be too helpful.
I had a similar problem when working on a product list (converting and modifying
Progress database lines into Solid/SQL database "through" Excel.
What helped me was that I formatted the *whole column* as text. No date (or
time) conversions after that.

Matti P.

 

[Jim Rech]

Looks like the only 'fix' is for the replacement string to begin with an
apostrophe - '2-3-2

--
Jim
| When cutting and pasting data, is there a way to turn off Excel's
(annoying)
| habit of automatically converting a cell defined as "Text" to a "Date"
| format? For example:
|
| 1. Create a new worksheet
| 2. Right click on a cell
| 3. Format cell as 'Text'
| 4. Enter the following: 2-2-2
| 5. Find (CTRL + F)
| 6. Click the Replace tab
| 7. Find what: 2-2-2
| 8. Replace with: 2-3-2
| 9. Click 'Replace All'
|
| Notice how excel has convert the cell from 'Text' to a 'Date' format. I
need
| the cell to show the 2-3-2 *exactly* as typed. I tried clicking 'Advanced'
| option and modifying the cell format, but it still makes some strange
| modification to the 2-3-2.
|
| Any ideas?
|
|
|

 

[Guest]

Unfortunately, that's not a "fix" when the hard copy is going to have an
apostrophe. * sigh *

 

[Jim Rech]

Another idea - turn on/off "Transition formula entry" before and after the
Find/Replace. This is the last "Excel Options" Advanced option.

--
Jim
| Unfortunately, that's not a "fix" when the hard copy is going to have an
| apostrophe. * sigh *
|
|
| "Jim Rech" wrote:
|
| > Looks like the only 'fix' is for the replacement string to begin with an
| > apostrophe - '2-3-2
| >
| > --
| > Jim
| > | > | When cutting and pasting data, is there a way to turn off Excel's
| > (annoying)
| > | habit of automatically converting a cell defined as "Text" to a "Date"
| > | format? For example:
| > |
| > | 1. Create a new worksheet
| > | 2. Right click on a cell
| > | 3. Format cell as 'Text'
| > | 4. Enter the following: 2-2-2
| > | 5. Find (CTRL + F)
| > | 6. Click the Replace tab
| > | 7. Find what: 2-2-2
| > | 8. Replace with: 2-3-2
| > | 9. Click 'Replace All'
| > |
| > | Notice how excel has convert the cell from 'Text' to a 'Date' format.
I
| > need
| > | the cell to show the 2-3-2 *exactly* as typed. I tried clicking
'Advanced'
| > | option and modifying the cell format, but it still makes some strange
| > | modification to the 2-3-2.
| > |
| > | Any ideas?
| > |
| > |
| > |
| >
| >
| >