Tried to use regex to convert info to formula to convert. Got result that is correct, but try to use value to get number and it fails with err:502 If I manually put the value in a cell it works, but it I put same value in cell with quotes it also fails. What am I missing??
03°15'090"E "=REGEX(REGEX(REGEX(REGEX(REGEX(A57,"°","+"),"'","/60+"),"""","/3600"),"[EN ]",""),"[OSW]","*(-1)") 03+15/60+090/3600TRUEcheck if text Err:502"=VALUE(A59) 03+15/60+090/3600"=CELL("CONTENTS",A59) Err:502"=VALUE(A61) 03+15/60+090/3600copy VALUE OF A61 Err:502"=VALUE(A63) 3.275"=VALUE(3+15/60+90/3600) Err:502"=VALUE("3+15/60+90/3600") +------------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor (Retired) mailto:mi...@guam.net mailto:msetze...@gmail.com Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy