-
I couldn't find reference to it anywhere else... Is it not possible to have a button on the comment textbox toolbar to format VBA code? I'm thinking of something like on DDoE (colour highlight, monospaced), but not necessarily in the frame.
-
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...
-
Was just upgraded to Excel2007 from Excel 2003. When I try to print any file created in Excel 2003 that has a pic/text box/ chart or any other object in the workbook it prints out of alignment(pics on text, text box/pics in different locations. It looks fine on the screen but when you print or print...
-
Yes, that's what I do to. I adjust the column width and get reasonable alighment. Must be a bug in the program!! I also experience the problem that when I'm in page layout, I can't always select a singe cell. The program selects a group of cells or rows when I click a cell. It drives me crasy...
-
I used Excel Explosion and created several files from my dataset. I selected the option to add alternate shading to every other line on the output. I've asked users to highlight changes that they've made to the file before sending back to me. The shaded cells won't allow a new fill color...
-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
Ali You could import it as text (*.txt or no extension at all) and using the wizard mark the columns you wish to hold as there exact representation as text (it's the third step). Then to convert those to numbers with the correct number of decimals you could read each cell, find the period and then...
-
This is probably an easy one for all of you... I have been creating a custom number format on new excel files almost daily. I want to create the format and save it so that the format comes up every time I open excel and start a new spreadsheet, just like the built-in formats. How do I keep the format...
-
Team I am having problem in Excel when it do the auto format. I have a text file which has the following data which are tab separated value Name Date Amount1 Portion XXX 12-5-2008 11.25 10/25 When i load this text file into excel.(By changing the extension from .txt to .xls) It convert 11.25 to 25-Nov...