Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I want to find how i can change the format of a column from general to numeric in file obtained from an csv file(so i can use function like "sum"). Thank's |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't think the "general" format is the problem. If the format is general
and you type in numbers you should be able to use functions like "sum". I suspect what's going on is your numbers were somehow put in as text. If this is the case, you can probably fix things by: 1) Type the number 1 into an unused cell (make sure it's numeric or general format before you type in the 1). 2) Select the cell with the 1 and copy it. 3) Do a "paste special" to all of the numeric cells that you want interpretted as numbers and select "multiply". 4) Try your "sum" or other function again. Will "viktor" wrote: Hello, I want to find how i can change the format of a column from general to numeric in file obtained from an csv file(so i can use function like "sum"). Thank's |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format Issue | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
convert cell contents to different data file format | Excel Worksheet Functions | |||
can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) |