|
|
|
|
#1
12-19-2019, 09:35 PM
|
||||
|
||||
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] 
|
|
| Tags |
| conversion, text, value_function |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formula to convert dates into text/values
|
Marcia | Excel | 2 | 07-01-2019 06:53 AM |
| Attendance table Text Value Convert to Number | NickFazer | Excel | 2 | 11-08-2018 01:29 AM |
|
Cannot Convert Text Cell to number format to be able to sort the data
|
jyfuller | Excel | 10 | 06-19-2013 05:31 PM |
| Convert Formula Result to Static Text | MYGS | Excel | 16 | 01-21-2013 08:18 AM |
| Convert Number to Text | devcon | Word | 0 | 07-10-2010 01:16 AM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode