-
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...
-
Following on the Andy's and adding a little. If the column widths are fixed but the row height isn't, you could set the text on the alignment tab (Home tab>Alignment Group) to wrap. It will then wrap at any space in the text where the next word is wider than the column width.