Hi
one way:
- format the cells with a number format
- select an empty cell and copy this cell
- select your range of data
- goto 'Edit - Paste Special' and choose 'Add'
If your data is in column A and if you only have integers,
type in cell B1: =TEXT(VALUE(A1),"0") and copy this down
(if you need text, if you need values, omit the text
function).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
