-
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...
-
Tony May not help as they will become text representations of the numbers so not used in any onward calculations but =TEXT(DEC2BIN(A1),"0000") Will do it
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
Thanks for your reply Roger. I also have Excel 2007 running on Windows Vista. I was able to successfully follow your instructions in Excel 2007 (Windows). Unfortunately, I have not been able to duplicate / crack the code for Excel 2008 Mac with your advice. It could be that I am missing something obvious...