User Profile
K_L_I_E_F
Copper Contributor
Joined Nov 04, 2020
User Widgets
Recent Discussions
Re: Responses changing from number to text
Movaan I was working on a responses that has number stored as text, and, since I needed to do a calculation based on the responses (to utilized its data and save time from moving the responses to another worksheet) I would need to convert the number stored as text into a number or value for a calculation to work. So I tried using the CLEAN function as you had suggested, though it removes the unprintable character ( ' ), there's still a need to convert the results into a values manually. I found this VALUE ie. =VALUE(text or cell) function which convert the number stored as text to value. This can also be a work around. All the best.27KViews2likes0Comments
Recent Blog Articles
No content to show