Excel Formats

J

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

JE McGimpsey

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

Peo Sjoblom

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

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'
 
Top