Issues with Excel
Thread Starter
|
Cargo Master
Joined: Apr 2003
Posts: 3,476
Likes: 224
From: Frequently frozen MN
Issues with Excel
I've used Excel for years, but I've recently come acrpss a couple of issues and I wonder if anybody has solutions. (And yes, I've used the Open Office equivalent at times, but I normally prefer Excel).
These issues have come about because I changed to a medical plan that uses a Health Savings Account. In order to track what's going on with the bleeping thing, I copy the data from various web pages into Excel. Then I can organize it a bit.
Anyway,
1. Hyperlinks -- web pages are always full of these. I can right click each cell and remove them, bur I'd like to find a way to do at least a column at a time.
2. Number and date formats. I simply cannot force some of the currency and date data into anything that Excel will recognize as numeric. I've never had this much trouble. I've tried paste/special/value, =value(cell),= datevalue(cell), and other tricks. Excel insists that the data is text, so I can't do any math or date sorting. I've actually just reentered the data in some cases -- sort of defeats the purpose.
I could probably save the web pages as .csv(s), but these would probably be messy.
Any thoughts?
These issues have come about because I changed to a medical plan that uses a Health Savings Account. In order to track what's going on with the bleeping thing, I copy the data from various web pages into Excel. Then I can organize it a bit.
Anyway,
1. Hyperlinks -- web pages are always full of these. I can right click each cell and remove them, bur I'd like to find a way to do at least a column at a time.
2. Number and date formats. I simply cannot force some of the currency and date data into anything that Excel will recognize as numeric. I've never had this much trouble. I've tried paste/special/value, =value(cell),= datevalue(cell), and other tricks. Excel insists that the data is text, so I can't do any math or date sorting. I've actually just reentered the data in some cases -- sort of defeats the purpose.
I could probably save the web pages as .csv(s), but these would probably be messy.
Any thoughts?
Hotshot
Joined: Apr 2004
Posts: 13,589
Likes: 2
From: NW burbs of chicago
for the hyper link part, Can you C/P into notepad or wordpad, the C/P into excel. That "should" fix it
the format part, I take it you've tried "formatting cells" I've had luck where I format a whole column.
the format part, I take it you've tried "formatting cells" I've had luck where I format a whole column.
Admom
Joined: Feb 2001
Posts: 9,414
Likes: 201
From: Silver Springs
What version excel are you using?
I use 2003 and when I print reports to excel my numbers always come in as text. When I click on any of the cells with text numbers in them, a little box with a triangle in it and a drop down arrow appears to the left of the text cell. I click on the drop down and choose the options "convert to number". I can even highlight an entire column or columns and change them all to numbers as long as the 1st cell I have highlighted is one of the cells with the text format number.
I've tried the =value and various formulas but none of them have worked.
I use 2003 and when I print reports to excel my numbers always come in as text. When I click on any of the cells with text numbers in them, a little box with a triangle in it and a drop down arrow appears to the left of the text cell. I click on the drop down and choose the options "convert to number". I can even highlight an entire column or columns and change them all to numbers as long as the 1st cell I have highlighted is one of the cells with the text format number.
I've tried the =value and various formulas but none of them have worked.
Tuned
Joined: Dec 2007
Posts: 393
Likes: 0
From: Santa Clara, CA
What version excel are you using?
I use 2003 and when I print reports to excel my numbers always come in as text. When I click on any of the cells with text numbers in them, a little box with a triangle in it and a drop down arrow appears to the left of the text cell. I click on the drop down and choose the options "convert to number". I can even highlight an entire column or columns and change them all to numbers as long as the 1st cell I have highlighted is one of the cells with the text format number.
I've tried the =value and various formulas but none of them have worked.
I use 2003 and when I print reports to excel my numbers always come in as text. When I click on any of the cells with text numbers in them, a little box with a triangle in it and a drop down arrow appears to the left of the text cell. I click on the drop down and choose the options "convert to number". I can even highlight an entire column or columns and change them all to numbers as long as the 1st cell I have highlighted is one of the cells with the text format number.
I've tried the =value and various formulas but none of them have worked.
forgot about this..it also work in Excel 2007
Thread Starter
|
Cargo Master
Joined: Apr 2003
Posts: 3,476
Likes: 224
From: Frequently frozen MN
Into and out of one of the 'pads' might just do it. Thanks
And yes, I've tried the format.
I'm using Excel 07 for this -- -- it was the only one I could buy new when I was looking.
Off topic mini rant -- I really hate the Office 07 'Ribbon' interface, and I minimize it most of the time. I can remember some of the older keyboard shortcuts and I use them. Why did they screw up a fairly useful interface -- that everyone was used to. I'm surprised that they don't remap the qwerty keyboard
And yes, I've tried the format.
I'm using Excel 07 for this -- -- it was the only one I could buy new when I was looking.
Off topic mini rant -- I really hate the Office 07 'Ribbon' interface, and I minimize it most of the time. I can remember some of the older keyboard shortcuts and I use them. Why did they screw up a fairly useful interface -- that everyone was used to. I'm surprised that they don't remap the qwerty keyboard
Hotshot
Joined: Apr 2004
Posts: 13,589
Likes: 2
From: NW burbs of chicago
Trending Topics
Hotshot
Joined: Apr 2004
Posts: 13,589
Likes: 2
From: NW burbs of chicago
FTE Stories
Ford Trucks for Ford Truck Enthusiasts
3 Best / 3 Worst Parts of Modern Ford Ownership
Brett Foote
10 Amazing Upgrades That Solve Common Ford Truck Owner Headaches
Pouria Savadkouei
Every 2026 Ford Engine Explained
Brett Foote
10 Ugly Ford Trucks That We Still Kinda Love
Joe Kucinski
10 Things Every Truck Owner NEEDS (2026 Edition)
Michael S. Palmer
Rezvani's Latest Post-Apocalyptic Monster Is a Ford F-150 Raptor Underneath
Verdad Gallardo
Top 10 Most Expensive Ford Trucks Ever Sold on Bring a Trailer
Joe Kucinski
2027 Ford Super Duty Buyer's Guide (Every Model, Engine, & Package)
Brett Foote
Top 10 Ford Truck Tragedies
Joe Kucinski
Thread
Thread Starter
Forum
Replies
Last Post
19fifty4
General NON-Automotive Conversation
16
Jul 14, 2012 10:46 AM
