-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formula read as text
- Thread starter djurmann
- Start date
Cbrine
Well-known Member
- Joined
- Dec 2, 2003
- Messages
- 3,196
If the formula is appearing in the viewable part of the text, it could be two things.
1. You have set the option to show formula's.
2. The field is formated as text.
To resolve option 1, just go into the excel option and uncheck the checkbox for the option. It's in the view tab.
To resolve option 2
1. Select the cell
2. Select Data....Text To columns in the excel menu.
3. When the wizard appears, just press finish.
4. Also format it as general in the cell format options, which should stop it from reverting to the incorrect format.
HTH
Cal
1. You have set the option to show formula's.
2. The field is formated as text.
To resolve option 1, just go into the excel option and uncheck the checkbox for the option. It's in the view tab.
To resolve option 2
1. Select the cell
2. Select Data....Text To columns in the excel menu.
3. When the wizard appears, just press finish.
4. Also format it as general in the cell format options, which should stop it from reverting to the incorrect format.
HTH
Cal
Upvote
0
Similar threads
- Solved
