Excel Formats

  • Thread starter Thread starter Jan
  • Start date Start date
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.
 
Copy an empty cell. Select your column. Choose Edit/Paste Special,
selecting the Values and Add radio buttons. Click Ok.
 
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'
 
Back
Top