Thread: Reliable way to convert text to number with a formula
View Single Post
 
Old 12-19-2019, 09:35 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Why do you need a formula? Simply type a 0 anywhere on any worksheet, then copy it to the clipboard, then select the range to convert and use Paste Special>Values>Add. The range to processs can even span cells that contain text (but not formulae). Empty cells will end up containing 0s, regardless of whether you check the 'skip blanks' option.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote