If the OP wants numbers instead of text he/she might want to add something
to
keep it numerical


=--(149&A1)



--


Regards,


Peo Sjoblom

"Spiky" wrote in message
...
On Aug 18, 3:56 pm, wrote:
Hi All,

I have a question as to whether there is a fast and easy way to enter
some digits into a cell that already has digits. For example, I have
a cell with the numbers 123456 and I would like to add 149 to the
beginning without having to manually go into the cell and add 149 to
it, as I have a LOT of cells to do this to. At the end, the result
should be 149123456. Any ideas?? I appreciate any help. Thank you in
advance!!

Jen

If it is always "149" that will be added, use Concatenate in another
column. Then copy the result back to your original column, Paste
Values only. Then delete the extra column.
=149&A1 or =CONCATENATE(149,A1)

If you have different things to add to each cell, use 2 columns. One
to enter the new digits and the 2nd for the Concatenate. Then do the
copying.

Or, for easier data entry, you can press F2 and then Home to get to
the beginning of a cell. But this will take longer.