Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the General forum. See all tags in the site
  • Formatting Cells around decimal points - Not Rounding

    Hi All, I have to upload a report to my company's bank account and getting the data set up takes way longer than I think it should. Can you help me figure out the least amount of steps to get a dollar amount to a text format? Everything I've researched involves rounding, which I do not want to...
    Posted to General (Forum) by meganexcels on Thu, Jan 2 2014
  • Text to Columns help

    Hi there, I am in need of help! I have exported contacts in from Microsoft Outlook 2010. We are needing the address to be split into the columns. I have included a sample of the data in this post (see Sampledata.xlsx). Can someone please let me know if there are any tricks to seperating the data? Thanks...
    Posted to General (Forum) by Hannah on Tue, Nov 6 2012
  • Help with the basics using excel 2003

    Hello and thank you for reading this, my first ever forum post. I have been driven to seek help for an issue i know you will able to help me with. Scenario: I have produced a spreadsheet to record student scores for a number of tests. each test has three cells to it 1: the score (entered by the instructor...
    Posted to General (Forum) by shaynetibbles on Sat, Jan 15 2011
  • Possible to password protect but still allow users to group/ungroup?

    Hi, I'm working in Excel 2003 (which this forum evidently no longer has a link to), and have created a template for users to input number data. I have defined the cells they can edit and password protected the rest of the form. I would like the users to be able to group and ungroup, but once I password...
    Posted to General (Forum) by Diver10 on Thu, Sep 9 2010
  • Long numbers converts from texts to scientific when copied from 2007 to 2003

    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?
    Posted to General (Forum) by Susan Lugent on Fri, Aug 13 2010
  • Excel Explosion and alternate shading to every other line

    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...
    Posted to General (Forum) by Linda Berardo on Tue, Mar 31 2009
  • ??? is there a way (function?) to store a number gained by calucalations into another cell where it is stored as a number free of calculations

    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...
    Posted to General (Forum) by caladdin on Mon, Jul 28 2008
  • Re: How to disable auto format

    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...
    Posted to General (Forum) by Nick Hodge on Thu, May 8 2008
  • custom number formats

    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...
    Posted to General (Forum) by Chiara on Mon, Apr 28 2008
  • Auto Format option in excel

    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...
    Posted to General (Forum) by subhakarthi on Fri, Apr 25 2008
Page 1 of 2 (13 items) 1 2 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.