Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Cell format from CSV file

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 173
Default Cell format from CSV file

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format Issue DS Excel Worksheet Functions 4 October 13th 06 01:20 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
convert cell contents to different data file format adam Excel Worksheet Functions 2 April 10th 05 08:39 PM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM


All times are GMT +1. The time now is 01:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"