Over 1 million tech questions and answers.

Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Q: Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Hey everybody.

I don't know if the title is a good one for this problem, but here goes.

I have a column that has numbers in this format: 54321-1234

Now, I want to take off the last 4 numbers, and the dash, from all the numbers in the column, using a formula. So that the output would be: 54321.

I want it so the first 5 numbers stay the same, but the dash and last 4 are gone. Is this possible?

Thanks.

RELEVANCY SCORE 200
Preferred Solution: Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Read other 13 answers
RELEVANCY SCORE 111.2

First time posting...I am working on a spreadsheet for work in calculating a benefit. I have listed in C13 a minimum benefit (currently $25, but it varies). Later in the spreadsheet I subtract two numbers (c32-c33). If the number is less than zero, I have the formula put 0 in C34 as the answer IF(C32-C33<0,"0",(C32-C33)). That works fine. The problem is that later I when I want to list out what to pay, if the final answer is less than the minimum, I want the minimum to show, otherwise I want the calculated answer to show. Here is my formula. IF(C34<C13,C13,C47) Everything works great unless the original numbers subtracted is less that zero....for example $600 - $600 - the final results spits out the minimum of $25. Perfect. But when $600 - $601 = really equals -1, but I have it showing 0, the final answer spits out 0, not the $25 that I want. Any ideas on what to do to get it to put the C13 value instead of 0? Thanks so much for the assistance!
 

A:Solved: 2003 Excel Negative numbers

Read other 11 answers
RELEVANCY SCORE 100.8

I've tried copying/pasting into Notepad; formatting cells into every format possible; have tried making another column, entering the =VALUE(A1) formula, and copying/pasting down the column; have tried Text to Columns; and find/replace $ sign...

When I export my data into Excel, I am unable to sort correctly and therefore, am also unable to Autosum.

Sorting results in:
$1,000.00
$110.00
$12.00
$50.00

Instead of by true value:
$12.00
$50.00
$110.00
$1,000.00

Please help! thanks in advance

*note, attached doc is just a sampling of the several hundred records from the exported report
Excel 2003, Windows xp
 

A:Excel 2003: sorting numbers incorrectly!

Peace be upon you
1- please apply this function =VALUE(TRIM(MID(B1,2,LEN(B1)-2)))
2- Pull down to all your values
3- mark Solved
Thank you and best regards
 

Read other 3 answers
RELEVANCY SCORE 98.8

I am exporting report data from an accounting program into Excel 2003, then having to change some of the worksheet data into to a specific format (some columns show dates, phone numbers, etc - which need to be converted to text - translation:HEADACHE) and then saving file as ".csv" to submit reports online to another agency. I am pulling my hair out here because it keeps changing to funky formats in the .csv sheet and I find myself back at square one. I am required to do this on a monthly basis, and will soon be submitting a similar file to a different agency, so I will double my headache if I can't get my head wrappred around this.

Any help would be great!!!

Thanks.

I'm running XP Pro sp3, Office 2003
 

Read other answers
RELEVANCY SCORE 91.2

Here comes the dumbest and easiest Excel question ever, folks....!

In 1 column I have 8-digit numbers like 73269090. I need them all to take on the format xxxx.xx.xx (7326.90.90). For the life of me I cannot figure out how to accomplish this in the "Custom" menu of "Numbers".

Who will help the most ignorant Excel user ever??

Cheers [email protected]
 

A:Solved: Reformat Excel Numbers

Read other 11 answers
RELEVANCY SCORE 91.2

i have used the code below, so that when i enter a number in cell e7 a running total is shown in h10, and all figures entered in cell e7 are shown individually in Column L, is it possible instead of entering a number manually, can the number be generated randomly when a command button is pressed, i would need numbers generated randomly between 0 and 50
Private Sub Worksheet_Change(ByVal Target As Range)
Dim WB As Workbook, ws As Worksheet, wsk As Worksheet
Set WB = ThisWorkbook
Set ws = WB.Worksheets("Sheet2")

If Not Intersect(Target, Range("E7")) Is Nothing Then
ws.Range("H10").Value = ws.Range("H10").Value + ws.Range("E7").Value
x = WorksheetFunction.CountA(Columns(12))
Cells(x + 1, 12) = Target
End If
 

A:Solved: random numbers excel

Read other 16 answers
RELEVANCY SCORE 91.2

Hello,

I am having trouble with Excel 2003 automatically adding the last digit in a Postal Code. For example, when I type in "R3R 4K5" in A1 and then click the corner of it and drag it down a couple of cells it goes from "R3R 4K5" to "R3R 4K6" and "R3R 4K7" and so on.

Is there an option that you can disable to prevent this?

Thanks!
 

A:Solved: Excel adding numbers

Read other 10 answers
RELEVANCY SCORE 91.2

Can anybody help with this question? I have a massive spread sheet with numerical data in it. on paper I have associated a number to different ranges.

For example in columb A any number that is between 25-30 needs to be converted to 0.375. Can anyone tell me a quick way to convert these and other numbers in one go?
 

A:Solved: Changing all numbers in excel?

Read other 9 answers
RELEVANCY SCORE 91.2

I've been trying to write a simple formalue for Excel to generate a random number in a cell when I press the 'enter' or any other key. I've been trying with using =randbetween(1,100)

Any tips please ??

thanks
 

A:Solved: Random Numbers - Excel ??

Read other 10 answers
RELEVANCY SCORE 90.4

I keep a monthly budget record of our expenses in worksheets labeled by month. There are 13 worksheets in a file (1 for annual total). I have row labels such as "wine, food, our cats, etc" & enter data from our joint account, as purchases are made, into each cell. E.G.: B12 might be: =34.66+73.45+2.68 etc. At the end of the month I "proof out" our account to reconcile it with my bank statement. There are always missed or multiple spreadsheet entries that make the excel total different from the banks & I have to find them. I use online banking & my probem began when the bank "upgraded" their online service & no longer allowed me to sort the debits by amount. Before they did this I could look at the excel cell entries & find them very quickly on the banks sorted printout & check them off. Since I can no longer sort the banks data it has become much more difficult to do this monthly chore. Is it possible to sort the multiple number entries in each cell & display them in a column? BTW: I don't mean to sort within the cell, but all cells contents together for display, so it will look like the banks used to look.
Any help really appreciaced.

Ron40
 

A:Solved: Excel: can I display all numbers in cells?

Read other 9 answers
RELEVANCY SCORE 90.4

I am trying to create a template in excel with the name, address, and number repeated three times on one page and then when the template opens again I would like it to assign the new name the next sequential number so that no numbers can be skipped or used twice. See below. Can you help? Thank you in advance.

Jane Doe
1 Main Street
Anytown, Fl
1101

Jane Doe
1 Main Street
Anytown, Fl
1101

Jane Doe
1 Main Street
Anytown, Fl
1101
 

A:Solved: Excel Template with Sequential Numbers

Read other 10 answers
RELEVANCY SCORE 90.4

Hi,

Can anybody guide me to generate continous numbers from 1 onwards while I filter the records? I need to generate these numbers in first column in order to know how many records are available after filtering.

regards,

Abdurazik
[email protected]
 

A:Solved: Excel - Generate countinous numbers

Read other 12 answers
RELEVANCY SCORE 90.4

Hi,

I currently have data that is pulled from a database with a collumn which represents the time a call was logged. However, the information in the cell shows as 130237 when it should show as 13:02:37. How can I manipulate this and also be able to change the formatting to time. Currently if I try and format it, it shows as 00:00:00

Cheers
 

A:Solved: Excel - Numbers into a time format

Thats coming in as a full date - so
130237 is the date

28/07/2256

if you change to a time format and also use value - then it will be seen as a time

assuming the time is in cell G8 and you always get leading zeros - which maybe a problem for 9am

=VALUE(MID(G8,1,2)&":"&MID(G8,3,2)&":"&MID(G8,5,2))
 

Read other 3 answers
RELEVANCY SCORE 90.4

I have an Excel workbook that prints many pages. With this workbook, after the 7th page I insert pages from a different program, and then the rest of the Excel workbook pages follow.

The Excel workbook is actually 20 pages long.

Example:
I need a way to create a macro that will insert 1 of 20 pages on the first seven pages of the Excel workbook pages. Then since 2 pages from another workbook will be added before the other 13 Excel pages, I need the numbering to reset to show 10 of 20.

Does this make sense? Can this be done?
 

A:Solved: Excel Macro -> Page Numbers

Read other 15 answers
RELEVANCY SCORE 90.4

Code:

B C D
time data result
12.00 1
12.05 1
12.10 1 3
12.12 - 2
12.25 -1 -3
12.40 1 1
12.55 -1 - 1
1.05 1
1.16 5 6

hi
can any body help in making a macro that sum the same signs numbers in column C and put the results in in column D as in the examples above
and every time that i start the macro ....it will start to calculate from the first cell D2 and go down
hope to find this macro
 

A:Solved: macro to sum numbers with same signs in excel

Read other 6 answers
RELEVANCY SCORE 90.4

Hello,

I was wondering why numbers show up that way and what it generally means.

I can double click each cell in the column and it will show the real number i need, such as:

634479009815

Is there a way to convert the whole row, so the numbers will show normally.

this should be just a general format.. this is just a generic id, and not currency or any other special format.

Thanks.
I use excel 03/07 both.
 

A:Solved: why do numbers show up as 6.34479E+11 in Excel. ???

Read other 8 answers
RELEVANCY SCORE 90

This was asked before by KlausdB:

"I have 4 x HDDs on SATA AHCI (Intel Controller) in Native Mode and 1 x ESATA on Win 7 Pro X64.
I noted that looking in Admin. Tools\Computer Management\Storage (as an example) the 1st HDD (Port 0 in the AHCI BIOS) is showing as "Disk 2" instead of my expectation of


"Disk 1".
Selecting the Drive's Properties correctly shows the "Location 0 (Channel 0, Target 0, Lun 0)".
I also note that the Disk Number allocation in Windows will change randomly after some reboots/startups - going anywhere from "Disk 1" to "Disk 4".  I can force/replicate this


behaviour by removing the ESATA drive.
Is this expected behaviour?
It doesn't appear to create any operating issues at this stage, however, is there a way I can force the Drive to always map to (eg) Device 0 --> Disk 1, Device 1 --> Disk 2,


etc?
Thanks."


 This was answered by Nicholas Li:

"As far as I know, how the disk is plugged physically and the order it is displayed are not related. For a simple example, if a drive is plugged to SATA interface 4 and it is the only disk, it will be displayed as Disk 0. If there is no related issue about
the disk order, I think we can safely ignore this."


 Because the topic was closed I want to ask a new question here:
 What happens if one of the 4 HDD drives or 5 has an OS installed on it? I ask because windows always write some bo... Read more

Read other answers
RELEVANCY SCORE 89.6

Id like to set page numbers at 7.2&#8243;, .5&#8243; below the top edge of the page

The page numbers tab provides these options only:

Position:
Top of page
Bottom of page

Alignment:
right-left-center-inside- outside

Is it possible to set margins for page numbers in word documents? And how?
 

A:Solved: Is it possible to set margins for page numbers in word 2003 documents

I believe this may be what you are looking for:

Step 1: Use what you have already described to insert page numbers as a header.

Step 2: Click on View.

Step 3: Select header and footer.

Step 4: Left click on the page number so that a little grey box contains it.

Step 5: Scroll over the little grey box containing the page number so that you get the icon that lets you move a selected item. The icon looks like the xy-axes from algebra.

Step 6: Hold down the left mouse button and move the page number to any place on the page you want it, even outside of the header. This will affect all page numbers on all pages. When the page number is where you want it, release the left mouse button.

Step 7: Close the header and footer box.

Hope this helps.
 

Read other 2 answers
RELEVANCY SCORE 89.6

My tools: Dell dimension, circa year 2000. Windows 98SE, OE, IE6. I do not use Outlook: too complicated.
Yesterday and today large numbers of virus-bearing messages have arrived by email. They originate from a variety of foreign countries-uk, Japan, Russia, etc. Almost all purport to be from Microsoft, or an announcement such as a message that did not go through. Yesterday, 57 of them. Today in 20 minutes since I logged on, 30 and counting, with many more indicated from the server of my regional dial-up provider.
Fortunately Norton antivirus and firewall have identified all thus far. Of yesterday's crop, all the viruses were known to Symantec and none needed to be sent in. All, of course, first quarantined and then deleted.
It does take a long time to wait, screen out the wanted email (I receive from 10 to 20 per day normally, with 0-3 bearing noxious material), and is a stress as well as a nuisance. I have on each message clicked on my OE toolbar Message, then Block sender. But still they come.
Have I any other way to get rid of this material in advance? It would be nice not to have to sit here like this.
Thank you for any help you may offer.
 

A:Large numbers of Viruses

You can set a message rule to have them all go into the trash folder instead.
 

Read other 3 answers
RELEVANCY SCORE 89.2

It's hard to come up with a snappy title that sums up my problem but I'm hoping it will be fairly simple to solve.

I've created an IF formula in an excel spreadsheet and I want to drag the cell across a few more cells. The formula will reference the same cell so I can make that an 'absolute reference' but then I want the logical test number to increase by 1 each time and the value if true to remain the same.

=IF($A$1>0,1) [in the first cell, then in the next to the right]
=IF($A$1>1,1) [then]
=IF($A$1>2,1) [and so on]

Can anyone please tell me if this is possible? and if so, how??!!

heres hoping,
Nellie.
 

A:Solved: Can you drag formula in excel so the numbers increase?

Read other 16 answers
RELEVANCY SCORE 89.2

I have used MS-Excel for many years and am fairly familiar with with using formulas. However I am a total novice when it comes to creating and using Macros. I am using MS-Excel 2003 and have run into a requirement that I don't think can be handled with just formulas.

I need to create several arrays of random integers. The number range and the quantity of numbers is determined by numbers entered into other cells. So far, I could do that with formulas. The catch is that each array can not have any duplicate numbers in it. There also needs to be an error check to make sure the number range is equal to or larger than the quantity of numbers needed.

I have attached a file that shows the workbook layout and includes examples of the type of arrays I need to generate. All help and guidance is welcome and will be appreciated.
 

A:Solved: Creating arrays of random numbers in Excel

Read other 16 answers
RELEVANCY SCORE 89.2

First, Thanks for looking !

I have to create a spreadsheet with numbers that repeat for merging into another program. The number sequence is:

1001
1001
1002
1002
1003
1003
1004
etc.

When I type in a sequence of them and then drag and fill I get the decimal versions after the original set I typed in, which since it is rounding, tends to jump or repeat a sequenced number:

1004
1004
1005
1005
1005
1006
etc.

How do I get it to repeat the number twice, but not skip or repeat based upon the rounding of the decimals that are hidden?

Thanks again!
 

A:Solved: Excel Autofill - Double Numbers Capable

Read other 7 answers
RELEVANCY SCORE 89.2

Hi

I am using office 2000 and windows 98. I just had it all re-installed and now when i open up an old spreadsheet it shows the negative numbers just with the minus sign infront of the number. Where as before all the negative numbers would automatically appear in Brackets.

Does anyone know how to change this back?
 

A:[SOLVED] Excel 2000 negative numbers in Brackets

Read other 7 answers
RELEVANCY SCORE 89.2

I have three columns in Numbers (Column H, J, and R). Columns R is an exact copy of Column H.
Every time a certain value appears in Column H, I need the corresponding value in Column R (but not Column H) in the same row to become negative.
Now, I have over 100k rows that I am working with, so manually changing seems to be out of the question.
How exactly can I do this?
 

A:Help with Numbers on Replacing Values

Hi Eraserboy, welcome to TSG.

You don't say what program you're using, but I assume Excel? If so, you can use an if formula. You don't say what value you need to find in column H, but I'll use 5 as the example. You'd put this formula in R1 and drag it down the rest of the column.

=IF(H1=5,-5,H1)

The formula says "if the value in H1 is 5, then make R1 = -5. If not, make it the same as H1". Replace the 5 and -5 with whatever value you need.

Hope that helps.
 

Read other 3 answers
RELEVANCY SCORE 89.2

I have three SATA hard drives :
Main system/boot drive , WD Caviar Black 1 TB, connected to the SATA 0 port
A backup drive, identical WD Caviar Black 1 TB, connected to the SATA 1 port
Another dirve, Hitachi 1 TB, connected to the SATA 2 port
When I installed Win 7, only the main drive was connected... and it remains the only drive with active/system/boot partitions.

QUESTION 1.
All three drives reporr correctly in the BIOS, and in the right order, but why is it that only one of the drive (the one on SATA port 1) has a "SATA:" prefix and the others have a "HDD:" prefix ?

QUESTION 2,
Why is it that the assignment of Disk #0, 1, 2 ( as seen in Disk Maanger or DiskPart) does not seem to have nay rhyme or reason?

I would have expected:

- the hardrive connected to SATA port O, to be assigned as Disk 0
- the hardrive connected to SATA port 1, to be assigned as Disk 1
- the hardrive connected to SATA port 2, to be assigned as Disk 2

but instead, I have:

- the hardrive connected to SATA port 2, is assigned as Disk 0
- the hardrive connected to SATA port 0, is assigned as Disk 1
- the hardrive connected to SATA port 1, is assigned as Disk 2

Just curious why that is.

I am assuming there is no way to chagne this. Its not something I would dream of reinstalling Windows 7 to correct ( even if it did correct it).

A:SATA port numbers vs assignemnt of Disk numbers/

Best advice, leave it alone. It may bother your (and others) sense of order but it won't affect how anything works, and no re-installing Windows won't change it.

Read other 9 answers
RELEVANCY SCORE 88.4

Hi All

I have a spreadsheet full of numbers formatted as currency. Some dollar amounts are positive and some are negative. I want all the negative numbers to be in red font. Instead of me searching for all the negative numbers (they are in the hundreds) and turning them all red manually, is there a simple macro that can do the trick? This will save me a lot of time. Since the numbers change from negative to positive and vice versa and the number of rows and columns also change, I'm having a hard time programming it.

Has anyone out there written a macro than can do this?

Thanks

Mario
 

A:Solved: Turning negative numbers to red font in an Excel spreadsheet

It's built into Excel - just highlight the cells, go to format cells.
Go to Currency. There are 2 boxes on the right - the lower one allows you to have negative numbers in parentheses ($3.00) or red $3.00 or a combination of those two or with a minus sign.
 

Read other 3 answers
RELEVANCY SCORE 88.4

Hello group,

I wasn't quite sure how to word the subject line. I would like to be able to add a number to column A everyday and have the cumulative sum of column A show in column B in the adjacent cell so I can chart it. So it would look something like this:

1 1
1 2
1 3
2 5
-1 4

I think it's something to do w/the SUM function but I can't quite figure it out. Any help much appreciated.

Harold
 

A:Solved: Excel: Adding Numbers in a Column on a Daily Basis?

Read other 7 answers
RELEVANCY SCORE 88.4

in all applications as9text is entered a 9 will pop in at random times, 9ee above, see above. Files sent to another laptop have also corrupted it with an alphabet of abcdefg51236*nopqrstuvwxyz.
Where ids the problem?
 

A:numbers replacing letters in text

Read other 6 answers
RELEVANCY SCORE 87.6

In my past I worked in a music store and took a handful of cd's home everyday to put in my computer, most of them are .WAV about 40 or 50K though I do have 15 or 20K MP3's. Is there a program available to sort through all this mess, and maybe help me remove some of the doubles I have recorded. It's becoming a nightmare to deal with, I have 8 250GB usb drives full of music, I figure if I rip the wav's to MP3 I can put the songs on just on or two harddrives, I just need some software that will let me do it in an orderly fashion. Any help will be really appreciated.
 

A:Music database for large numbers of songs>60k

you could probably use itunes or windows media player etc to convert them to mp3 format, then sort the library by name/albums, and delete duplicates from there, but makeing sure you click on 'remove from library and computer'...

although keep a backup of the original files while you figure this bit out from the programs just incase it deletes everything there, then delete them when its all good...

and make sure its only reading from teh one folders/drive
 

Read other 2 answers
RELEVANCY SCORE 87.2

I have Windows XP, with Wordpad v5.1 and Notepad v5.1 as well. In Notepad, if I toggle off Word Wrap, I can then toggle on the Status Bar, and it shows me the line and column number in the status bar. It does not look like Wordpad has the ability to show line and column numbers. Does anyone know if there is a way to show that in Wordpad? Thanks.

Read other answers
RELEVANCY SCORE 87.2

I was checking my program and software list and at the top of the list I noticed two (2) sets of numbers that I have never seen before. I checked the internet to see if I could find out what they were. It kept taking me to sites for spyware, adware,etc. I could not find out what they were or why they are on my system. I do not want to remove them until I know what they are. I have not noticed any problems with my system, but I do not know what might be going on behind the sceen. The numbers are listed as follows:
{684CB795-C157-4E15-93D4-E26015FEF1EA}

{F850707C-B6A0-4B56-8709-F89CF8F9AC6D}

ANY HELP?

A:Found Numbers Unknown Numbers In System

The first one > http://www.acresso.com/products/is/i...d-overview.htm

The second one > http://eraser.heidi.ie/

Both are legit and not malware.

Read other 1 answers
RELEVANCY SCORE 87.2

I have been given four transcripts of telephone calls recorded at a call centre. All at different times on the same day. Two have the same callID number. The sequence of the numbers attributed to each call are odd. The first call has a higher number than later calls and the last two are also out of order. I am not sure if this is the right forum but i am desperate for some help. The transcripts are VERY important and I cannot be sure that they are the real deal because of the callID numbers. Any suggestions? Thank you in advance.
 

Read other answers
RELEVANCY SCORE 87.2

I'm using VLookup & need my reference numbers on the current and the lookup pages to have that left apostrophe at the beginning of both sets of reference numbers or otherwise to have no apostrophe there at all. Without consistency I can't perform the lookup.

Is there a quick way to add or remove those apostrophes in a long list of numbers?
 

A:(Solved) Excel: remove/add apostrophes at beginning of long list of numbers

Read other 14 answers
RELEVANCY SCORE 86.4

Howdy,

I have an Excel document with hundreds of values all with leading zeros.
The number of zeros varies from cell to cell, and the cell lengths may vary, so I might have something like:

00000123
000000012004
00555555
00000000000000ABC
00DEFGHIJ

I need to remove the leading zeros from all cells.
I can't multiply by the values by 1, because of the non-numeric entries.
I can't Replace All zeros, cos it would replace any zeros that appear within the codes, not just the leading ones.
I can't do a Replace All searching for * then a specific character, because the first char of the code is not specific.

So I'm thinking I need to do something like:
=RIGHT(A1, FIND(<>"0",A1,1)-x)
Obviously that doesn't work, cos it doesn't like the <>"0" part, and I can't put a set number in place of the "x" at the end as the number of characters to return differs from cell to cell.

Or maybe use the SUBSTITUTE function somehow, though again I still need to tell it to stop when it hits a char other than zero, as =SUBSTITUTE(A1,"0","") applied to line 2 in my example data above would return 124 instead of 12004.

Thanks!
 

A:Solved: Excel - remove leading zeros (differing numbers) in Text cells

Hi Gram. I checked ASAP Utilities but couldn't see this covered.

Sub Macro1()
For Each Cell In Selection
x = Cell
If Left(x, 1) = 0 Then
Do Until Left(x, 1) <> 0
x = Right(x, Len(x) - 1)
Loop
End If
Cell.Offset(, 1) = x
Next Cell
End Sub
 

Read other 2 answers
RELEVANCY SCORE 84.8

Whilst my daughter was playing with the computer yesterday she downloaded something that has introduced a malware that has stopped AVG from working and has shut me out of turning it on, starting a scan or updating. Additionally it has introduced large numbers of pop ups (many of which are dodgy in the extreme). Any help would be greatfully recieved.

A:Malware disabled AVG and causing large numbers of viruses to enter computer

I should add that I have searched through the hidden files folder and not found anything suspect and wonder if the combo fix software is the way forward?

Read other 14 answers
RELEVANCY SCORE 82.8

My page numbers appear fine in the slides but don't appear in Print Preview and will not print up????
 

A:Page Numbers - PPT 2003

if you goto
insert
slide number

and tick slide number there

Mine is on print preview OK
 

Read other 1 answers
RELEVANCY SCORE 81.6

Hi all

When I enter a phone number into excel it chops the 0 off from the start. I've checked in
formatting but can't find the option to stop that.

Could anybody help me.

Thanks in advance.
 

A:Excel and phone numbers

Read other 16 answers
RELEVANCY SCORE 81.6

Hi recently when I work in Excel I cant use the the numbers on the right side of my keyboard when numlock is on I can use the top row of numbers above the tab,q,w,e,r,t,y number keys just not the keys on the right side. though I ca use it with notepad is there possibly a setting I can change within excel or has excel become corrupted? Please this is extremely urgent!!!
 

A:Excel sand numbers

Read other 7 answers
RELEVANCY SCORE 81.6

I'm about to start working on the side doing some basic updating of ISBN's on a management site. I'm trying to hash out the issues I may encounter before I give a definite yes since it's family that I'll be working before. Here is my potential issue:

Say you have these two numbers:

1.) 0012345678
2.) 0000023456789

I know the way to format it so that the two zero's appear in front on a 10 digit number but what about when you would have 10 and 13 number ISBN's in the same excel sheet? If I were to do this:

1. Right-Click-> Format Cells
2.) Custom-> Type-> 0000000000

That would take care of any 10 digit numbers but it would make the 13 digit number lose some of the zero's.
Any ideas? I am not an Excel expert because I deal more with general repairs and deployments.

Thanks!!!
 

A:ISBN 10 and 13 Numbers in Excel

is it worth changing all the 10 isbn to 13 anyway - with this info
http://ndpsoftware.com/isbn.php

heres the formula
http://www.nationallibrary.fi/publishers/isbn/revision.html
 

Read other 1 answers
RELEVANCY SCORE 81.6

In Excel, when one has a scatter diagram, and values such as 9.81, 19.62 and 29.43 on the x-axis, how can one get Excel to display the decimal numbers on the x-axis, rather than have 9.81 be set a little before 10, 19.62 be set a little before 20 etc. ? thanks,

Christian K.
 

A:Excel x-axis numbers

Try building a line chart first using just the y values.

Then select the range on the chart -- you'll get something like

=SERIES(,,Sheet1!$B$1:$B$3,1)

in the formula bar. Click between the 2 commas, then click & drag on the x values (on the worksheet).

If you *must* stick with scatter, try Rob Bovey's free Labeler add-in at http://www.appspro.com/utilities/utilities.asp

Rgds,
Andy
 

Read other 2 answers
RELEVANCY SCORE 81.6

How do I spell out numbers in Excel, i.e., twenty five dollars and fifty cents. Is there a macro out there that can do this?
 

A:How to Spell Out Numbers in Excel

Actually, there is.

You can download this sweet thang here for free (it's ALWAYS been free):

http://www.asaputilities.com

or just do a search on the web for "convert numbers to text Microsoft Excel"

They're all over the net...
 

Read other 2 answers
RELEVANCY SCORE 81.6

Hi

Please can someone help. I am trying to convert a list of 16 digit numbers from text into general so that I can do a v-lookup from another spreadsheet.
I am highlighting the column where I want to paste the numbers and formatting as custom with 16 #'s, pasting my original data into a notepad and pasting it into the new pre-formatted column.

Annoyingly, Excel is changing 4476707465712132 into 4476707465712130 which is driving me mad! I've tried using a new spreadsheet and lots of other things and it doesn't help. Now realised if I just randomly enter 16 digits into a cell, what displays after I hit return isn't what I've typed.

Please help!
Thanks
Abby
 

A:Excel Rounding Up Numbers

see here
http://support.microsoft.com/kb/65903

only retains 15 digits
 

Read other 1 answers
RELEVANCY SCORE 81.6

I have an excel spreadsheet (2002) Someone has entered in all the numbers that are supposed to be negative numbers like this 14.56- when you try and add all the numbers all together it returns a zero value because excel doesn't understand that it is a negative number because the minus sign should be on the other side of the value.

Does anyone know of a good idea on how to get all the - signs on the other side of the number or any quick way to make excel understand these numbers as a negative eg -14.56????

Help!!!
 

A:Excel Negative Numbers

Read other 8 answers
RELEVANCY SCORE 81.6

I know by formatting the cell you can select negative numbers to appear in red. I was wondering if there was a way to do that with zeros?
 

A:Excel and negative numbers

Hi there,

Yes, there is, but you'll need to do a custom format as there are no default formats for showing anything equal to zero in red. Now in order to do this, you'll need to understand a little of custom formatting. There are four items you can specify, and they are in specific order: Greater than zero, less than zero, equal to zero, and textual values. These items, are separated by a semi-colon ( ; ). So something like this...
Code:
0.00;-0.00[Red];0.0[Blue];[Green]
This should explain them a little more...

http://office.microsoft.com/en-us/excel/HP051995001033.aspx
http://www.ozgrid.com/Excel/CustomFormats.htm
http://www.exceltip.com/st/Replacing_Zeros_with_Dashes_in_Number_Formatting/66.html

HTH
 

Read other 1 answers
RELEVANCY SCORE 81.6

I'm doing quite a long spreadsheet in Excel and need to number each row sequentially. I know there used to be a way to do this but maybe it was in an older version of Excel. I'm currently using Excel 2002. I tried using a forumla to add one to the row number above but realized when I sort the sheet by a different column, the row number changes. If anyone can tell me how I can number the rows without having to hand type each number, I would appreciate it.
 

A:Sequential numbers in Excel

Read other 8 answers
RELEVANCY SCORE 81.6

I'm currently having a problem regarding random number generating, as I can't seem to find the answer anywhere. Anyway, my problem is that I am generating random numbers from 1 to 55, however, the probability of each number being chosen is already given. I know that if you use randbetween function, that the probability of all numbers being picked out is equal (in this case, each number has 1/55 chance of being picked). My problem is that I am already assigned some probability for each number to occur (like 5% for 1, 7% for 2, 25% for 3, 2% for 4, and so on...), and the random number generation should be based on that list of probabilities given to me. How do I do that?

Please do forgive me as I am an excel newbie, and I have utterly no idea what I'm supposed to do next.
 

Read other answers