Discussion Locked

Preventing Excel from changing a text fe

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I currently am having difficulty with Excel changing a feild to a date feild when using the search and replace function. The data in the feild is a location in our warehouse with is in the format of 00-2-01. When I go in to search and replace these feilds excel changes then to a date feild automatically. I have tried to set the format of the entire document to text and also the cells themselves to text feilds with no luck. I have looked in the options panel also to see if I could turn this function off but have had no luck. Any help on this would be appreciated.

5 replies

by larry h.

One way to do this is to add an apostrophe to your replacement text. For example:
FIND: 01-02-01
REPLACE WITH: '02-02-01

Excel uses the apostrophe to indicate that the text is a label and not a value, but it will not print or appear on the spreadsheet itself, just when you look at the cell contents.

by tjc

Right click on the cell and choose format and then click "General"

This discussion is closed to new replies.