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