Recent content by JoannDavies

Thanks for the advice, xl. I see I have a 3.5 which is set at OEM and a 4.0 set at ANSI. That could be a clue! I will pursue this further with the IT peeps. Joann

I import a lot of text files into Excel. Most of the time the file origin is already set to Windows(ANSI)when I go through the import process, but not always. Is there a way to make Excel always default to Windows(ANSI)? I'm using Excel 2003 but will soon be converting to 2007. Thank you...

Thank you both for the ideas! Joann

I have 2 columns in Excel. Column A is a list of companies in a not so clean format: FordMCo MaybeIBM maybe not 4m of NH Smiths etc Column B is a list of companies nicely clean and neat: Ford IBM XYZ 4M etc Is there some code I can run to identify which companies in column A might match...

Sorry I didn't reply before, but I got sidetracked onto another job. But I'm back again now and this was just exactly what I needed. Thank you so much! Joann

Another rounding problem! I've searched the posts and can't quite make them work for what I need! I need to be able to round a number down (always down!) to the nearest quarter (.00 or .25 or .50 or .75). Can anyone help me? Thank you! Joann

Thanks, Mike, that sounds nice and simple and just what I need... I'll give it a try. Joann

I have a user form which has text boxes linked to cells in a spreadsheet. The cells in the spreadsheet are formatted just how I want the numbers to appear - no decimals and with a comma. The contents of the cells link just fine, I see the numbers I expect to see, but the formatting in the...

I'm doing a User Form in Excel and I want to link one of the text boxes to data in a particular field in my spreadsheet. This works just fine when I type, for example, "b4" in the ControlSource Property. It links up just fine and shows the data from cell b4 in Sheet1.... However...