Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fields Not Reconizing #s....EXCEL 2000 1

Status
Not open for further replies.
stlrain95

stlrain95

Programmer
Sep 21, 2001
224
US
I have data that has been imported either Tab or Space deliminated and when I try to do a formula to SUM the #s in one column....it doesn't recognize the numbers.

I have tried to reformat.

HELP!!

Thank you,
 
Sort by date Sort by votes
Try multiplying all cells in that column by 1.

Ilse
 
Upvote 0 Downvote
Hi,

Your data in that column has been IMPORTED as TEXT.

Either import that column as General or

create a new column and reference the numeric text column
Code: 
=VALUE(A1)
Then you can copy that column and paste it back into the original column with Edit/Paste Special-Values

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
574
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
517
SkipVought
S
C
  • Locked
  • Question
Office 2000 XL
Replies
6
Views
1K
dhookom
dhookom
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
347
combo
combo
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
928
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top