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).
