Excel Formats

[Jan]

I have a column of numbers which were taken from a csv
file and they will not format as a number field. They are
left aligned in the cell and the format cell option does
not convert the column of numbers to a number format.

 

[JE McGimpsey]

Copy an empty cell. Select your column. Choose Edit/Paste Special,
selecting the Values and Add radio buttons. Click Ok.

 

[Peo Sjoblom]

Copy an empty cell, select the numbers, do edit>paste special and select add

 

[Frank Kabel]

hi Jan
probably the numbers are stored as text format. Try the following:
1. Format the column as number/general (goto 'Format - Cells')
2. Enter a 1 in an empty cell, select this cell and copy this cell
(CTRL+C)
3. Select the column with your numbers and goto 'Edit - Paste Special'.
Select the action 'Multiply'