-
Our shop is in transition from excel 2003 to 2007. When we copy long numeric values from Excel 2007 into 2003 the data displays fine at first but when we format the data to text it displays as scientific. How can I convert the data in 2003 to text and have it not display the scientific format?
-
Hi Everyone, I am an average Excel user using 2007. I am trying to type text in a text box such that I place text in the the 1st line, skip a few lines by hitting the <ENTER> key, then add my next line of text. The problem is when I hit the <ENTER> key, nothing happens. Also, if I hit the...
-
All- Please help. I am entering a concatenate formula that is showing me the correct result in the function input box, but the result is not populating in the cell. I have used Excel for years and I have checked the autocalculation option; it is on autocalculate. When you copy the formula down to other...
-
Normal 0 21 false false false MicrosoftInternetExplorer4 <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font...
-
I have created an elementary line chart in an elementary single sheet workbook. When I print at 100% scaling under page setup all is fine. If I fit to the page, requirng an scaling at 75% to fit, the chart no longer prints or appears in print preview in the correct place. It seems as if the scaling on...
-
One of our users created a file using 2007, and saved as .xls. When others try opening the file, in 2007 the message is: Access Denied. Contact your administrator In 2003, the message is: Excel cannott access 'filename.xls'. The document may be read-only or encrypted. I think he was messing with...
-
Dear friends, I have a file for which i had put some password in the past and now im not able to use any of the normal password which i use normally. Can anyone help me on how do i reset the password now. Also is there any free softwares available for doing this job. THanks in advance Regards MAthew
-
L.S. I would like the code for a button like the Paste button in the Clipboard Group on the Home tab. A button which you can click but also with extra options in a drop down. Can someone please hint me in the good direction thnx
-
I have about 20 macros on an Excel 2007 spreadsheet. I have added buttons into the QAT. Unlike Office 97 - the buttons aren't labelled and the design of each button is limited to the choice of 180 available. You would think this was enough, but it isn't . What happened to the ability to design...
-
Hi all, firstly I am wanting to plot a non linear XY data set (essentially 2 sets of nearly linear data with different slopes). then I would like to start working from the end pair of XY point with a linear trendline adding a pair to the trendlne fit at a time, examining the r value (correlation coefficient...