Quote:
Originally Posted by macropod
To add the +64 prefix you could either:
1. input 64000000000 into a cell, copy it to the clipboard, select the cells to update and use Paste Special>Values>Add, plus a custom number format (+0) to add the + prefix;
The first method retains the numbers as numeric data; the second converts them to text.
|
sorry - struggling with this one, any further detail that would help me please?
Edit - sorted it out - used flash fill after manually inputting the first one. Text is fine for the use I have. Thank you
11-06-2016, 09:30 PM
Similar Threads
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C
Windows 7 64bit 
Office 2013
Threaded Mode