Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
I am a very new user of Excel so bear with my "green-ness";
1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
First basic question:
If you enter a formula and it appears in both the formula bar and the cell, odds are Excel thinks the material is just a text string Take a typical problem cell: 1. clear the cell 2. format the cell as general 3. re-type (NOT PASTE) the equation -- Gary's Student "cjtj4700" wrote: I am a very new user of Excel so bear with my "green-ness"; 1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
Not necessary to clear the cell.
Just re-format to General then hit F2 and ENTER. Gord Dibben Excel MVP On Wed, 23 Nov 2005 16:19:03 -0800, Gary''s Student wrote: First basic question: If you enter a formula and it appears in both the formula bar and the cell, odds are Excel thinks the material is just a text string Take a typical problem cell: 1. clear the cell 2. format the cell as general 3. re-type (NOT PASTE) the equation |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
Possibly in Options you have selected "Show formulas"
Tools Options = View Tab Formulas is selected. Unselect it. "cjtj4700" wrote: I am a very new user of Excel so bear with my "green-ness"; 1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
Perfect. Thank you very much. Any ideas on part #2? It is an internal
shipping request form and I want staff memebers to not only have to select a service level (overnight, ground, etc.) but only be able to select 1 of them?? thx "cjtj4700" wrote: I am a very new user of Excel so bear with my "green-ness"; 1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
Try DataData ValidationAllowList.
Either type the list into the dialog box(comma delimited) or have the list on the sheet and select that list range. Checkmark "in cell dropdown". Users will use the dropdown list to select one of the options from the list. For more on DV dropdowns see Debra Dalgleish's sit. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben Excel MVP On Wed, 23 Nov 2005 21:34:02 -0800, "cjtj4700" wrote: Perfect. Thank you very much. Any ideas on part #2? It is an internal shipping request form and I want staff memebers to not only have to select a service level (overnight, ground, etc.) but only be able to select 1 of them?? thx "cjtj4700" wrote: I am a very new user of Excel so bear with my "green-ness"; 1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
Joe
Instead of copying from Outlook try FileExport from Outlook as a *.csv or *.txt file. Open that file in Excel and see what you get. Gord Dibben Excel MVP On Wed, 23 Nov 2005 21:34:02 -0800, "cjtj4700" wrote: Perfect. Thank you very much. Any ideas on part #2? It is an internal shipping request form and I want staff memebers to not only have to select a service level (overnight, ground, etc.) but only be able to select 1 of them?? thx "cjtj4700" wrote: I am a very new user of Excel so bear with my "green-ness"; 1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
2 basic Excel questions for you pro's
Ignore this post.
Was meant for somewhere else<g Gord On Thu, 24 Nov 2005 09:49:08 -0800, Gord Dibben <gorddibbATshawDOTca wrote: Joe Instead of copying from Outlook try FileExport from Outlook as a *.csv or *.txt file. Open that file in Excel and see what you get. Gord Dibben Excel MVP On Wed, 23 Nov 2005 21:34:02 -0800, "cjtj4700" wrote: Perfect. Thank you very much. Any ideas on part #2? It is an internal shipping request form and I want staff memebers to not only have to select a service level (overnight, ground, etc.) but only be able to select 1 of them?? thx "cjtj4700" wrote: I am a very new user of Excel so bear with my "green-ness"; 1) I have been creating links throughout my 13 sheet workbook, now when I attempt to finish making these links today, the actual formula (=SUM(A36)) is populating into the cell and not my data???? 2) I have a section that I want users to be able to only select 1, like "choose only 1" in a survey. When you select 1 cell, your previous selection moves, etc. Thanks in advance for the help~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
Excel template and access questions | Excel Discussion (Misc queries) | |||
excel 2003 questions | Excel Worksheet Functions | |||
excel 2003 questions | Excel Discussion (Misc queries) | |||
I Visual Basic Error "File Not Found" when Excel opens | Excel Discussion (Misc queries) |