Excel 2010 :: New Spreadsheet Won't Format Numbers

Jan 16, 2014

Open a brand new spreadsheet whether the format is set to "General" or "Text" it will not let me enter numbers. For example, when I enter 2007 in the cell it displays 20 07 not really that big of space between the two zeros - but still a space. I can't format this no matter what I do.

View 1 Replies


ADVERTISEMENT

Excel 2010 :: Number Format Keeps Switching To Date Format?

Aug 1, 2013

I have an Excel 2010 spreadsheet where the default number format keeps switching to the date format. I keep switching it back and it'll stay as a number format for a time, but then it'll switch back. This is also the case for any new worksheets in that one spreadsheet.

This only happens with this one file - everything else behaves according to my regional settings or to how the file had been previously formatted.

View 3 Replies View Related

Excel 2010 :: Formatting Numbers Written In Text To Numeric And Pulling Only Numbers Out

Feb 20, 2013

I am extracting data from a website to excel 2010. my problem is the data contains both text, numbers, and sometimes a combination of both.

e.g. hi im ron for more information you can reach me at 6 five 6 four 5 seven 7 three 2 two..

I need it to look like this 6564577322 or 7 * 0 * 2 * 4 * 5 * 6 * 8 * 6 * 2 * 1...i need to look look the same

How do i first format the numbers written in text into numbers and then show only the numbers in a cell minus the text?

View 3 Replies View Related

Excel 2010 :: How To Get Map Of World On Spreadsheet

Sep 9, 2013

Im using excel 2010. Im looking to have a map of the world in excel. I work in sales with 2 other people and we wish to divide the world up by countries.

It would be nice to have the names in a list and colours represent the countries.

View 2 Replies View Related

Excel 2010 :: Setting Up A Large Spreadsheet?

Mar 2, 2013

I'm have Excel 2010 and Windows XP. Each week I get 3 spreadsheets and each has data unique to it. Each spreadsheet has a week number column which is common to all three. I want to combine the three worksheets into one and make create several dynamic charts for management. How should I organize a large spreadsheet? In addition to my week number I have a host of other date fields. Some of the data I get is (1) vehicle VIN numbers (2) City/State/Country (3a) I break up the VIN to give me vehicle type (3b) year of assembly (3c) car type (3d) number of doors (4) mileage (5) complaint (7) defect code etc. etc. What are the do's and don't when setting up a large spreadsheet? I have data by week which goes back to 2006 and so my date fields go top-down. I inherited the three spreadsheets and would like everything under one roof, so to speak. One spreadsheet which I can make my charts.

View 1 Replies View Related

Excel 2010 :: Cut / Paste Jumps To The Top Of The Spreadsheet?

May 23, 2013

I have a system running Windows 7 Professional (32 bit) and MS Office 2010.

In Excel 2010, I have a spreadsheet that contains several hundred rows of data. When I cut and paste a section of data, Excel jumps to the top of the spreadsheet. This does not happen when I copy/paste, just cut/paste.

View 1 Replies View Related

Excel 2010 :: How To Add A Date Picker In Spreadsheet

Oct 14, 2013

I just want to add it to my excel 2010. How can I add a date picker in my spreadsheet, when the cell contains a date format????

View 14 Replies View Related

Excel 2010 :: How To Regroup Spreadsheet Data

Nov 13, 2012

In Excel 2010, spreadsheet with part # in column A and customer code in column B. Many part numbers have more than one customer buying the part.

I need to rearrange the information in the example below, where there are two part numbers:

Part Cust
334 CCC
334 CHD
334 CIL
401 CIL

Looks like the layout below, where there are still 2 columns, part # and customer, but with the customer(s) concantenated in column B:

Part Cust
334 CCC, CHD, CIL
401 CIL

Can this be done with any wizard type tool (pivot table, etc)? I am sure it could be done with VBA.

View 5 Replies View Related

Excel 2010 :: Who Saved Last Entry Into Spreadsheet

Jul 14, 2014

We have a spreadsheet on a server.Without using code is there a way to show who saved the workbook last?

using 2010

View 1 Replies View Related

Excel 2010 :: Hyperlinks Not Working When Spreadsheet Moved

Oct 17, 2013

Using MS Excel 2010.

As I understand it hyperlinks set in a spreadsheet should work regardless of where you save and/or copy the spreadsheet i.e. as long as the directory location of the location / file the hyperlink is referencing doesn't change (notwithstanding, the user must have appropriate access rights to the relevant directory locations)

However, the situation I have is the spreadsheet was generated and saved to directory location A (intention being this would be the 'master' yearly template) and the hyperlinks set, all of which work when you open the spreadsheet in this directory location. But when I copy the spreadsheet to directory location B, which is intended to be the yearly 'register' location for the spreadsheet, none of the hyperlinks work? When I hold my cursor over a link in the copied spreadsheet, in directory B, I do not get a 'pop-up' path like I do in directory A and when I click a link I get an error message:

Microsoft Excel The address of this site is not valid. Check the address and try again.

As stated above the documents the hyperlinks relate to have not moved, they remain in the same template directory (i.e. the link path has not altered).

View 1 Replies View Related

Excel 2010 :: Extracting Data From Large Spreadsheet

Jan 31, 2014

I work with Excel 2010 and have a very large spreadsheet with data that I need to manipulate in several different ways. I have been filtering and then cutting and pasting but this is very time consuming . Is there a way to extract specific data from the spreadsheet and transfer it to different worksheets? I don't really know how to use macros.

[URL] .....

View 14 Replies View Related

Excel 2010 :: Importing Online Data Into Spreadsheet

Jun 2, 2014

I have been tasked with streamlining a process to collect data from a specific online website (Web of Science) and import it into an Excel 2010 spreadsheet.

Currently they are going to the website, entering a short number of search parameters and then manually recording the pertinent data from the webpage. They would like to be able to enter a keyword in Excel (which acts as the search item) which then automatically does the rest of the process and provides them with a spreadsheet of the required data.

Is this possible? Perhaps by using Visual Basic code within Excel? I also saw a method that employed SharePoint Server 2010.

View 3 Replies View Related

Excel 2010 :: Allow Multiple User Access To Spreadsheet

Aug 22, 2012

We have a spreadsheet on a server location with macros. Different users will access the spreadsheet from one pc on different shifts. Is there a way to set the area as a Trust Location for all users on the PC or enable the macros in the spreadsheet to execute for all users without having to set up the spreadsheet trust location or macros for each user? I would like to have the spreadsheet accessable to any user on the PC without setting up individual access. The users can change for shift to shift.

View 2 Replies View Related

Excel 2010 :: Enter Formula For Volatility In Spreadsheet

Oct 10, 2012

Im trying to enter a formula for volatility in my excel 2010 spread sheet

my hig low close is listed verticaly in A,B,C

The formula for D1 is supposedly “={LN((A1)/(B1))}^2”

The formula for E1 is supposedly =SQRT(SUM(D1:D10)/10)*SQRT(252)*100

I put this in D1 and it is giving me an error

View 3 Replies View Related

Excel 2010 :: Placing Pictures From Folder In Spreadsheet

Jan 17, 2013

We updated excel from 2003 -> 2010 and this stopped working.

We have a macro which takes pictures from a folder and pastes those pictures in the excel -sheet.

At 2003 the pictures were correctly pasted to their positions, but at 2010 the pictures appear in somewhere at the same sheet. (not at the right places, which should be at column "o" at the same row.)

Macro (working correctly at 2003) :

Sub Kuvan_piirto(ic As Integer)
On Error GoTo loppu

SourceFile = Enari
DestinationFile = "Live1.JPG" ' Define target file name.
FileCopy SourceFile, DestinationFile
ActiveSheet.Pictures.Insert("Live1.JPG").Select

[Code] ..........

What should I change for 2010?

View 1 Replies View Related

Excel 2010 :: Pulling Email From One Spreadsheet To Corresponding Customer On Another

Oct 18, 2013

I am using MS Excel 2010.

I have a workbook with 2 separate spreadsheets.

Spreadsheet 1: GOLD
3 Columns:

A1 Number, B1 Name, C1 Acct Bal D1 (Empty)

Spreadsheet 2: Email
2 Columns

A1 Number, B1 Email

I would like to pull the email address for the corresponding Number From the Email sheet to the GOLD spreadsheet and have it end up in Column D

There are more rows in Sheet 2 than 1. I have already narrowed down the ones I need in Sheet 1. (Sheet 1 has 150 rows, Sheet 2 has 7315)

View 1 Replies View Related

Excel 2010 :: Macro That Will Draw Information From Spreadsheet

Apr 7, 2014

I am new to Excel VBA and am trying to create a macro that will draw information from a spreadsheet. The code i have written so far is shown below:

Sub Event1()
'Dim Event Date As Double
Dim Message As String
Dim Ans As String

' Prompt for Data

[Code] ......

The section i am having issues with is shown in red above.

What i am trying to do is have a message box pop up with the information as shown based on a date being typed into the the original box that pops up (Please enter a date and click on OK). The following message box then displays the required information from the spreadsheet.

View 4 Replies View Related

Excel 2010 :: Populate UserForm In Word With Data From Spreadsheet

Feb 19, 2013

I have a word template that gives a popup when started for the user to fill out. At present this is okay, but it is hard to maintain. So what I want is to be able to add all needed information in Excel - since our tools have the possibility to export my needed info to this.

I have a spreadsheet in Excel 2010 named 'Input TR'. This info I want in the popup macro in word. When choosing name from a dropdown menu - I want Excel to give me the choices instead of having it in the coded macro. After I have choosen the name - I want the product belonging for this name in the 'Product/Service:' dropdown menu, e.g Test 1 will give the value 1...5. (I will only be able to choose one of them)

Today - everything is coded in the word2010 macro, and thus difficult to maintain.

View 5 Replies View Related

Excel 2010 :: Launch Word Docx Embedded Within Spreadsheet

Sep 6, 2013

I have a word docx embedded within my spreadsheet .

Both are on Office 2010 versions and I have named the embedded word doc

docx = CCPBlank (named range)
sheet = Support Data

I want to open the word doc from within the spreadsheet from a user form I already have created for other module calls.

Any simple VBA code to open the embedded docx?

I have looked a previous posts and not sure they are suitable. I have embedded the docx as I want to ensure only that empty version is opened each time. It also means I only have to send one file (xlsm).

View 2 Replies View Related

Excel 2010 :: Using Autofill On Spreadsheet That Includes Filtered Column?

Jun 27, 2014

I am working with a very large spreadsheet 10k references... I need to add sequential numbers in a column to identify the references but I need to use he filter in the author column due to the way my referencing software exports the data...

When I try to use the pull down autofill it just keeps repeating the last or second last number of the cell - the autofil box that usually appears has disappeared.

Im using excel 2010

View 2 Replies View Related

Excel 2010 :: Lines Count - How To Expand Amount Of Columns In One Spreadsheet

Dec 27, 2011

I'm using Excel 2010. One spreadsheet I'm using has 1048576 lines and is a XLSX file. The other file has 65536 lines and is also a XLSX file. When I try to do a VLOOKUP, I'm given an error stating "invalid reference. This file version cannot contain formulas that reference cells beyond 256 columns or 65536 lines.

If both are XLSX files how do I expand the amount of columns in the one spreadsheet with 65536 lines? I thought all XLSX files had a million lines.

View 4 Replies View Related

Excel 2010 :: How To Keep XLS File Format

Jul 1, 2014

Isn't there a checkbox somewhere where I can tell Excel 2007 to leave xls files as they are? My Excel 2010 doesn't urge me to save an old xls file format into xlsx but in Excel 2007 I can't find a switch (and I don't rememeber if I had to do anything in 2010). So ultimately I want to stay in compatibility mode when using old files.

View 2 Replies View Related

How To Find Missing Numbers In Excel Spreadsheet

Dec 24, 2012

i need to find the missing numbers from 12 rows of 20 numbers.

ie, i have these numbers (only between 1-80) and need to find the *normally* 2 numbers that are not in that list between 1-80. there are 14 rows in this example

134810131417182832464855565758596475
412131417212223303235374044545861707880
57101117202528303435363940495155606264
35121823254148495051565860646670767879
311161719212225262829404447586063697578
126713162326353638394652535863707678
710172021272930414445464750515569727374

[code].....

these numbers wont be the same every time, but in theory after i enter 12 rows there should be only 5/6 numbers left max.

i need a script so that when i copy/paste 12 rows, i can be presented with the numbers not in that field. or even if i have a field of 1-80 displayed, then i copy paste my numbers in the fields below and can somehow highlight which numbers between 1-80 aren't in my pasted fields on the 1-80 field.

btw the numbers missing here are 24-68

ps im using excel starter 10 if that makes a difference

View 6 Replies View Related

Excel 2010 :: How To Fix Cell Text Format

Dec 17, 2011

i am trying to work on a database that has some errors that i want to correct the issue is that some of the cells have data that is listed last, first instead it needs to be listed into first last.

I can not seperate this into 2 fields as it would break the program this database belongs to.

this database is linked from excell to access i am using excell to update an access database

i use office 2010

View 9 Replies View Related

Excel 2010 :: Custom Cell Format

May 5, 2014

In cell 'I6' if I enter the text "Balance" I would like it to display as "Actual" but if any other text is entered I would like it to display the text entered. How to do this using custom cell formatting. (Currently on Excel 2010).

View 2 Replies View Related

Excel 2010 :: Changing Format Of Dates In A Column?

Oct 19, 2013

I am working with a 2010 Excel spread sheet and need some direction.

One column has dates in it. Some dates are like dd/mm/yyyy (eg 15/03/1974) and others in the same column are in the following format 14th October 1983.

I need all of the dates to be in the first format (dd/mm/yyyy).

Is there a way to do this without manually changing each field? I have already tried highlighting the column, then clicking the 'numbers' arrow and picking 'date' from the number tab but that didn't work. It's never that easy, is it?

View 14 Replies View Related

Excel 2010 :: Save As Cell Name In XLSM Format

Jan 28, 2013

I am looking for a vba to use a button to save a file using the cell as its name and save the file in xlsm format. I am using Excel 2010.

View 12 Replies View Related

Excel 2010 :: Macro To Format All Cells In Column According To Value

Mar 27, 2014

I need Macro to Format all cells in column according to value. The cutoffs are >20, between 21 and 50 (>21;<50) and greater than 51 (<51).

I have macro to consolidate cells from multiple files to single workbook. Now I have to 'color code' the value in all cells in column 'B', all as part of one large macro.

View 1 Replies View Related

Excel 2010 :: Maintain Pasted Chart Format

Oct 23, 2012

Using 2010 - When I paste a chart I can initially retain the format of chart bar colours (Paste Special - source formatting). But when I select a new data source for the chart the formatting of the colours is not retained.

View 1 Replies View Related

Excel 2010 :: Conditional Format Cell Which Contain Formula?

Jan 16, 2013

I have a large spreadsheet that I would like to indicate the location of the cells (Change cell color or text color) which contain formulas. My thought is that conditional formatting would be the easiest way...

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved