When a cell returns the text #VALUE!, how can I convert this to read the number 0?
T trotterpig Mar 20, 2010 #1 When a cell returns the text #VALUE!, how can I convert this to read the number 0?
S Simon Lloyd Mar 20, 2010 #2 look here for error handling ! http://tinyurl.com/ydvv3b When a cell returns the text #VALUE!, how can I convert this to rea th number 0? -- Simon Lloyd Regards Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
look here for error handling ! http://tinyurl.com/ydvv3b When a cell returns the text #VALUE!, how can I convert this to rea th number 0? -- Simon Lloyd Regards Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php)
× ×ž×™×›×ל (מיקי) ×בידן Mar 20, 2010 #3 Have a look at Excels help regarding the function: ISERR Micky
