Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
F2 enter in Excel to change the for
Name: ScottD Date: October 16, 2003 at 11:29:29 Pacific OS: xp CPU/Ram: ?
Comment:
I have two columns of data that I need to compare using some formulas (vlookup, conditional sums, etc..) my problem is that while the two columns appear to be the same format (some text string) one is actually text and the other is actually general. Therefore the above mentioned formulas do not work. If I change the format in one of the ranges of cells to the to match the other then I have to hit the F2 key and the enter key to make the cells change to the new format. Can anyone please tell me a quick and easy way to effectivly do the same thing as an F2 enter in each cell. I have thousands of cells to do this to. Thanks! ScottD
Name: Lpoulas Date: October 16, 2003 at 13:44:41 Pacific
Reply:
Whenever i have encountered this problem, I import the spreadsheet into Access, then export back into excel.
It is an extra step, but removes the formatting problem.
0
Response Number 2
Name: Bryco Date: October 16, 2003 at 21:29:50 Pacific
Reply:
Maybe I am missing something but Select your range of cells, right click on anyone of them and select Format, Cells.
HTH Bryan
0
Response Number 3
Name: ScottD Date: October 17, 2003 at 05:07:06 Pacific
Reply:
Thanks for the access suggestion, I will try that. If anyone else has a suggestion or MACRO that I could use to force excel to do an "F2" and "enter" that would be appreciated too.
0
Response Number 4
Name: Taxi Date: October 17, 2003 at 06:01:35 Pacific
Reply:
u mean "ctxt" and "cnum" function don't work in ur case?
0
Response Number 5
Name: Taxi Date: October 17, 2003 at 07:04:36 Pacific
Reply:
neither u can also use the data/convert and then choose "text" in the last option...?
0
Response Number 6
Name: ScottD Date: October 21, 2003 at 09:32:50 Pacific
Reply:
I can't find anything in the DATA drop down menu that is called converter. Maybe it is part of an excel add-in that I dont have? I have not been able to find a "ctxt" or "cnum" fuction either. Where would I find those in the menus?
0
Response Number 7
Name: Taxi Date: October 23, 2003 at 23:40:57 Pacific
Reply:
It's in standard menu usually..! My excel is in french and of course u can add what u want to ur menu by right clic on toolbar and choose "customize" . Functions can be found with the insert / function, then look in the text submenu .U should find there a tool to convert text to number (ctxt in french) and reverse (cnum in french). Data conversion can be autoopen when u bring a file with .txt . Try to save ur excel sheet as a text, and next open it with excel . It'll normally open the data/convert (or import).
0
Response Number 8
Name: ScottD Date: October 24, 2003 at 06:45:16 Pacific
Reply:
I think I found the functions that you are talking about. In the english version of excel those functions are called "Text" and "Value". Thanks for your help Taxi.
Summary: Hi,every month to process some database file we required to check weather database is modified on specific disk drive or not and what is the modified date. can we create the macro in excel to get the ...
Summary: Hiya, I want to include a hyperlink in excel to send the file to a specified e-mail address, it's purely an internal document. I thought I may be able to use mailto: but this sends a blank e-mail, I n...
Summary: Hi, I want to change the colour of the cell when some value is entered in the cell and i want to configure this for the whole work sheet...... Can anyone help me on this, i know its a primitive questi...
0 
