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
  • Number formats not working on pasted data

    Hello all, I have a thoroughly outdated system to keep a log of call centre stats. In order to facilitate a marginally easier workflow, I have rearranged a few things so that a user simply has to copy and paste data from reports into the worksheet. The worksheet is set up with all the number formats...
    Posted to General (Forum) by goisisi on Sun, Jan 5 2014
  • 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
  • How to stop users moving a cell by accident

    Hi All I have a protected worksheet where all but a dozen cells are locked. The unlocked cells are in A1:A12. Occasionally, instead of entering data into A1:A12, the user will drag one of those cells onto another one unintentionally. Often they have no idea that they have moved a cell. Formulas in columns...
    Posted to General (Forum) by keghead on Sun, Nov 15 2009
  • Copying and Pasting with a Macro, multiple times.

    Hi there, I have a file with a decent amount of rows (thousands and thousands and thousands and...) In one of the columns, highlighted light red in the attached file, I have three rows of an address. I would like to create a macro that will go down the list and cut the second lines of the address and...
    Posted to General (Forum) by fraserk on Wed, Nov 11 2009
Page 1 of 1 (4 items)
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.