Why do you want to just change the format? Why not the value itself? Like use =(B3+C3)*10^6 for million =(B3+C3)*10^9 for billion etc.