Help, My Columns Now Have Numbers Instead Of Letters.

A coworker asked me to help him with his excel file. He opened a file that had numbers instead of letters in the column labels, now he is seeing it in other files he linked that file to. How do you change it back? The name box even says R34C7 or R23C90 for Row and Column.


Free Excel Help Forum

- Ask any question about Excel and have it answered in no time.

Similar Excel Tutorials

Make Column Headings Numbers instead of Letters - Make R1C1 Style References in Excel 2007
In Microsoft Excel you reference columns as letters by default - A1, B3, C5, etc. But you can also reference the co ...
How to Resize Rows and Columns in Excel Quickly
Resizing rows and columns in Excel is an easy process. Simply left click in between the columns and drag the mouse ...
Convert Column Number to Letter Using a Formula in Excel
How to get a column letter from a number in Excel using a simple formula. This is an important thing to be able to ...
Quickly Resize Multiple Columns or Rows at Once in Excel
How to quickly resize multiple columns and rows at once in Excel.  This avoids having to individually resize rows ...

Helpful Excel Macros

Prevent Saving a Workbook under a Different File Name
- This Excel macro prevents the user from saving an excel file or workbook under a different file name. The file can only
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie
Delete Only the Text from Cells
- This macro will delete all text from selected cells. This will not delete any other characters or numbers from any cell
Excel Macro to Save a Specific Worksheet as a New File
- This Excel Macro allows you to save a specific worksheet within the Excel Workbook to its own new file. You will be a
Save the Current Worksheet as a New Excel Workbook File
- This Excel Macro will save the currently visible/active worksheet (the one that you see when you run the macro) to a

Similar Topics







I'm using Office 2003. Excel column labels used to be letters A-B-C etc, but
somehow got changed so both rows & columns have number labels. I would like
to go back to letters for column names, but haven't been able to find out how
to make the switch.



Title says it all really!!

For some reason, instead of letters, my row headings have numbers. This is making reading formulas incredibly confusing.

How can I change the row headings back to letters?

TIA


Help! I have one document where I can't see my row numbers or column letters
on my spreadsheet. This makes it difficult to select rows or columns to cut
and paste elsewhere. Is there a way to display the column letters and row
numbers (not on printed output, but on monitor)? This document was created
by a former co-worker and I have to modify it every year. There are numerous
formulas and details to start from scratch.



Hi,

I have a list of values which include letters and numbers:

ADP45
DSVC54
DEPT25 etc....
In the next column I want to only see the letters without the numbers:
ADP
DSVC
DEPT

Is there a function to do this?

Thanks.

Isa.



Hi,

I basically have two files lets say file A and file B. File B has more than 20 cells that are linked to file A. The problem am afraid off is that each job I name files differently based on the custormer name or what ever. I want to use the same files content (as a template) for each job with the links between them as is but I belive file B (which will be D) will not recognize cells in file C because it is linked to file A.

I am trying to get your help if there is a way to have file B or D update links and have them change file name (not cell locations) automatically. As you know a link between two seperate files will include the file name between brackets followed by worksheet name and cell number as shown:

='[A.xls]sheet1'!B10

To make it even simpler, if I input file A's name in a cell in file B, can I use the content in that cell to update the linked cells path i.e. change the previous file name with the name in that cell and keep sheet name and cell number the same?? Is this possible???

I really appreciate your help and suggestions. If someone has a butter idea he is more than welcome

thanks

Haab


hi.. i want to find all the possible combinations of 8 characters including letters and numbers.
The letters should be all capitalized and the combination should be letters and numbers alternately.
This are the examples:
C8L8J1A4
A7C8H2I4
Q8F9H6D9
Q1A9C8J9


Hello,

I have an excel form that has some letters in front of some numbers, and I need to find a quick way to remove those letters without having to go to each one.

Ex: CLAYMCD5147760000017845
CLAYJCD5790270000002446
CLAYMCD5147761000012541 CLAYMCD5147760000021224 CLAYMCD5147761000023088

I need them to just be the following on the excel column.
514776000017845
579027000002446
5147761000012541
5147760000021224
5147761000023088





I know this question has been asked a bajillion times, so I apologize for the redundancy.

I am working with an Excel spreadsheet and saving it as a .csv file in order to upload to an application that parses out the .csv data as transactions. The system requires .csv files, so this is how I need to save my doc (with this extension). I have been successful at preventing Excel from coverting that long number into scientific format. I have saved as a TXT file, pasted the longer number and it displays correctly. That is all good. But I have to save as a .csv. So if I do that, close the Excel window, and then open again (as the .csv file), the numbers are back to being displayed in scientific format. I have tried creating an Excel doc from scratch and entering text in Text format, to see if this created a cleaner file. But again, the second I save as .csv, close the window and then open that file up again, that dang scientific format is back.

Does anyone have any idea of how to work around this? Once I have successfully gotten the numbers to display as the long-chain number, how can I get them to "stick" so that they don't revert back to scientific format when I reopen the file?

Thanks so much for your help!


Hi,

I am copying cell values from one column to another using VBA. I can do the copy/paste fine I just need to determine if what I am pasting contains a letter so I can determine what column to copy to. The cells all contain numbers so I will only need to seperate numbers combined with letters.

I need to do the opposite for another column but I need to determine if cells containing letters have any numbers and place them in the proper column.

Any ideas?

Thanks,
Brian


Hello,

I need to create a CSV file to be able to upload large quantities of data to my website. However, one of the variables is written is Cyrillic (i.e. Russian, Ukrainian) letters. When i try to import the created CSV file after having entered all my data into excel, the information in that field is not recognized properly. All that happens is that a bunch of question marks appear in place of the letters. ????????? ???? ??????

I dont know what to do.

Please help,
Dennis


I am trying to format a column so I can enter 5 digits only. It has between 5
and 7 digit numbers in it right now and I need to delete the remaining ones.
It is about 350 numbers, so it would be a lot of work to go into each cell
and delete the remaning numbers. Is therea way I can format the whole column
to allow 5 digits? The same happened with letters. I had codes in it that
consisted of numbers and letters and the client only wants the first two
letters to remain. How can it be formatted so only 2 characters are allowed
to keep me from having to enter each cell separately?



I have a problem that I am looking for a little help on...

I have a CSV file (comma delimited) that I am opening in Excel. One of the columns contains 8 digit hexadecimal numbers. When I open this file in Excel any of the hex numbers that have a hex "E" in the number are being converted to scientific numbers.

Example: 00089E58 is being converted and displayed as 8.9E+59

I really need these numbers to just simply display as is, even as just text. I do not need Excel to recognize them as hexadecimal or numbers at all. I tried converting the column to text after the file was opened but the scientific notations remain.

This file has ~50000 rows with probably 5% being converted into this unusable scientific number. I do not want to manually update these numbers if possible. Any help would be greatly appreciated.

Excel 2003


I have been on here before trying to solve an issue that I have with a file that I am trying to make. I am trying to sort multiple columns of data by the letters contained within them and then by the numbers that are in them. After that is executed I would then like to take the sorted information and filter it even further by keeping all of the like number in the same row all the way across, if certain columns do not have the numbers other columns have I would like for a black fill to appear in that box. Can anyone help me out... I have attached a file to better explain what I am trying to accomplish the unsorted tab is the before and the sorted tab is the result that I am looking for. Thanks


hey guys...as my name says I am a complete novice but need to sort some data urgently

I have a problem I hope someone here can help me with...I have a single column of data about 1500 rows long that I need to sort from a - z...

the problem is that the letters of the data that I need to sort alphabeticaly...are preceeded by a group of numbers which in some rows their are 5 numbers before the letters & in other rows their are 6 numbers... this is throwing off the results of the a-z sort...

My question is their anyway I can use excel to just sort the letters & ignore the numbers?

any help would be greatly appreciated


regards


I used the "kill" function to delete a file that I replace daily on a shared network drive. The file is a read-only excel file. If I happen to replace the file while someone has it opened using the kill function, would I get an error and also what would the user who has it opened experience? I figured I'd ask here instead of doing a test with a coworker.


This should be simple to do ...but I'm stumped. I have a spreadsheet with
legislative district numbers that contain numbers while others contain
numbers and letters:

1
2
2a
2b
3
4
4a
4b
4c
5
etc.

I have tried converting the cell format to text and that does not work.
Please understand that I am not Excel literate and any answer must be in
simple but detailed terms that someone who could break a crowbar in a sandbox
can understand.



I have some project numbers in column A. They contain letters and numbers. Other codes are in column A as well and I have been able to isolate them without a problem but they were all numeric. Some projects are billable and others are not(noted in column C). I was trying something like this. =IF(AND(C1="B",A1=_______),D1)

D1 has the value that I would like to place in the current cell if the forumla is true. The underlined portion of my if then formula is where i am having the problem. First, if it is possible, is there a way to say if the cell contains letters then use it? If that is not possible is there a way to format the cell to numerical even though it contains letters, this way i can use a few > or < functions to isolate the data I need.

Thanks,


I am trying to get Excel 2007 to work for me rather than the opposite.

I have a database that I am extracting data from by year that consists of a column for a customer name, a column for a file number, and a column for a liability amoumt (other columns are present but not important at this stage)

First, I need to programatically color all duplicate file numbers within a customer name, all triplicate file numbers

Second, We have some instances where we may have file 123 and 123A which need to be colored as a duplicate. The problem is that not all file numbers are the same (genereated by the customer not us) and the ending piece may be a -1, .1 or a letter

I know the first part should be simple -- but I have run into a brain freeze here

Can anyone help?

Thanks


This is very odd. I cannot find Excel files that contain specific strings.
For example, if I create a new file, and in the first cell type in "123456".
Then save the file to the folder c:\Temp
Then in Windows Explorer, right-click on C:\Temp and select "Search . . ."
Then under "A word or phrase in the file", type in: 123456
It will NOT find the file ! ! It will find a txt file or a doc file, but not xls files.

I thought maybe it fails because that is a number.
But I have hundreds of Excel files with Integer numbers stored in "General" format cells and I desperately need to be able to search them to see which files contain certain numbers.

It all started with some files that were sent to me - they work PERFECTLY for searching cells for numbers. So strange - yet if I open the file then save it . . . no changes or edits at all, just Open and Save . . . then the search fails for all numbers in that file.

This is so perplexing that I have placed 2 zip Sample files on my website for you to Download


http://www.infocellar.com/Samples.zip

Unzip the two files to any folder.
One is named "Sample-Works.xls" - Then do a Windows Search for any number in the file, here is one to try that is in the two files: 174026
And it will list "Sample-Works.xls" but it will NOT list "Sample-Fails.xls", even though BOTH FILES ARE IDENTICAL !! I copied the same file twice and then named them. The only difference is that I opened the file Sample-Fails.xls and then immediately Saved it, which as I stated earlier, makes it fail all Searches from that point forward.

Also please try this - using Windows Explorer, copy the good file and then redo the Search. You will see both the good files show up as having "174026". Then open the copy you made and save it - now that file will fail to show up in the Search ! !

I did try this on my other PC, by the way, and the same Problem exists.
I also tried numerous Search Utilities (Agent Ransack, File Boss, PowerDesk File Finder, Turbo Search, etc) and they all have the SAME problem. There is simply no way to Search an Excel file for a number unless it is one of those files that were emailed to me a while back.

Any ideas? Anyone know how I can search Excel files and find the files that contain specific Integers ? TIA

ls

For some reason when I save an Excel 2003 file, it saves the file and adds an automatic copy by assigning a filename consisting of letters and numbers, with an unknown format. How can I stop this from happening?


i have just opened a spreadsheet in excel, and rather than the columns
showing as A B C they are showing the same as rows, in numbers 1 2 3. This is
not normal and i can't write formulas.



Hi,

I have a list of letters + numbers in sequence down a column.
The numbers are prefixed by a letter in alphabetical order.
When I sort the the column the numbers sort in (I think) numeric format
(example below)

What I'd like to do is find out if any values are missing from a sequence
and highlight the row before and/or after the missing value(s).

I know this can be done with conditional formatted when the column is a sequence of only numbers (no letter prefix)
and also sorted normally eg. 1,2,3,4,5,6,7,8,9,10 vs 1,10,11-19,2,20,21,22,23 etc.
http://www.viloria.com/secondthought.../00001358.html

A1
A10
A11
A12
A13
A14
A15
A16
A17
A18
A19
A2
A20
A21
B1
B10
B11
B12
etc



Thanks for your time,

Dino


Hi,

What I want to do is to click a file in Windows Explorer and then drag
and drop it into a cell of an opened Excel file to create a hyperlink
to this file (i.e. later on if the linked file is a PDF file and if I
click the link, it will open the file in Adobe Reader. Of course, it
does not work in the way as I thought. Instead, Excel reads the file
into a worksheet. I wonder whether anyone has an idea how to achieve
this. It is just too tedious to use Insert -> Hyperlink to create the
link if there are many files to be linked. Thanks for any suggestion.

Paul.




Morning all,
I have searched for an answer before posting this thread, so apologies if this has already been covered.

I am an average user of Excel 2003 to manage a 1.7mb shared workbook, from which 40+ users input data. I have 3 main serious problems:

1) Although shared, occaisionally I get the message " the file is locked by USER, please save with different file name

2) At least twice a week, my workbook becomes corrupt and a series of weird files appear next to the Original file. These files have no extension, no description, they look like temporary files, but do not delete themselves, always 8 characters in length, a mix of numbers and letters.

I delete these files when they appear, remove the sharing, save the file, then share it again to prevent corruption, but 2 days later, same happens again. I am unable to open the original spreadsheet, but if I click on one of these weird files, it opens up to my workbook????

3)when I remove sharing, a number of users appear in the list, but are not actually in the file. Or the same name will appear twice with different dates.

I appreciate any thoughts you may have with these issues.

Many Thanks

Jet-Leon


Hi

I am trying to include letters w/ number in a cell and still have Excel add up the column.

For example column might look like this:
1
2
1 AHV (in same cell)
1
1 CHV (ditto)

but when I add the letters to the cell, Excel stops recognizing the number and doesn't include it in the count:
1
2
1 AHV
1
1 CHV
_____
4 (The correct answer should be 6)

Thanks for your help.

Rebecca