What is the protocol for converting text to a number. For survey purposes I have 1,2,3,4,5,N/A - so if it's a # - I convert it from text to the number and if it's N/A I make it null (for averaging) - but I'm not sure how to make the text format a number.....
Anyone know this offhand??
Lisa
Anyone know this offhand??
Lisa