Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Two excel problems
I am using Excel 2000, I have two problem, one small, one big Small problem I have a worksheet with just under 5000 rows and half a dozen columns. Two of the columns contain telephone numbers. Unfortunately in the conversion of the data to get it into a format that excel could use the leading "0" was stripped from the phone number, how can I put the "0" back in again (I don't have access to the original data so I can't rerun the conversion). Big problem This ones a little harder, I have a worksheet with around 40 telephone number on it in one column (call this worksheet Y). I have another 10 worksheets (call these worksheet a,b,c,d etc.) which contain imported telephone bill information (numbers called, duration, cost etc.). What I want to do is see how often the number listed on worksheet Y appears on each of the worksheets a, b, c, etc. Anyone tell me how?? Regards Tim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
OfficeXP 2002 / Excel....Problems with emailing. | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Is Excel causing me system problems? | Excel Discussion (Misc queries) | |||
Problems pasting images into Excel | Excel Discussion (Misc queries) |