accidentally entered #'s as %s

i have a hugh spread sheet.  the numbers were accidentally
entered as percentages.  how can i get rid of the
percentage formatting w/o the decimal point changing position.

ie.   i want -0.251% to read -.251.  when i undo the
percentage formatting it ='s -0.002514568.

sorry:( i know it's a basic question, but i can  figure
this out for the life of me.

thanks


0
anonymous (74722)
10/7/2004 8:56:58 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
435 Views

Similar Articles

[PageSpeed] 27

put 100 in a cell somewhere, and copy this cell, select the region o
your values, and paste special, multiply, and reformat to numbe

--
duan
-----------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1162
View this thread: http://www.excelforum.com/showthread.php?threadid=26743

0
10/7/2004 9:16:57 PM
Reply:

Similar Artilces:

Can't Find, Re-subscribe or subscribe to any Excel NG's
I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor (with real-time Intelliscan), MBAM, SAS and Cleaner, Office 2007. I might be posting on the wrong NG but that's because I cannot seem to subscribe anymore to any Excel NG's such as: Microsoft. public.excel.anythingatall, so I can't set up a new post. Each of these NG's related to Excel is declaring that there are "no posts available anymore". I used to be subscribed to Microsoft. public.excel.setup, Microsoft. public.excel.programming, Microsoft. public.excel.general, and a few...

Column chart with 2 Y axis's
I have two Y axis, the secondary is 10x the primary in values. The 1 data series plotted against the secondary axis shows up right on top of the 4 data series plotted against the primary axis. Is there some way to avoid this, so all 5 data series appear side by side with no overlap? Thanks!!! Norm PS Excel 2002 & WIndows 2000 Pro Father Guido ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ I plan on living forever... so far, so good Plot the data series you want on the secondary axis not once but 5=20 times. Ensure all of them are on ...

Casio Men's Pathfinder Solar Triple Sensor Watch #PAG50-1V
Casio Men's Pathfinder Solar Triple Sensor Watch #PAG50-1V - Cheapest Watch Casio Men's Pathfinder Solar Triple Sensor Watch #PAG50-1V Link : http://www.watchesprice.net/Casio-Mens-Pathfinder-Solar-Triple-Sensor-Watch-= PAG50-1V-4018.html Cheap Watches Home : http://www.watchesprice.net/ Lower Price Casio General Brands : http://www.watchesprice.net/Casio-General= -Watches.html Casio Men's Pathfinder Solar Triple Sensor Watch #PAG50-1V --- one of best selling watches, it is crafted in high quality Watches. Casio Men's Pathfinder Solar Triple Sensor Watch PAG50-1V Description...

Pressing Enter to skip rows
We have a pro-forma in Excel for clients. Anyway, the cells where the enter information from a drop-down list are three rows apart, goin down the page. Is there anyway for the client to press Enter just once and go thre rows down rather than pressing enter three times? I am aware that if the sheet is locked with the particular input cell unlocked then Tab will take you to the next box however, we need Ente to do the same. I imagine a macro could achieve this. Thanks in advance D -- DoctorWar ----------------------------------------------------------------------- DoctorWard's Profile...

How to know that character type in one cell of xls is more that s.
Q : How to know that character type in one cell of xls is more that s... E.g How i will come to know that i typed more than specified charater, when i am typing in that particular cell Your character to test is in A1 In another cell enter =CODE(A1)>CODE("s"). You will get TRUE or FALSE Or use =IF(CODE(A1)>CODE("s"),"Bigger","Not bigger") -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dharamendra" <Dharamendra @discussions.microsoft.com> wrote in message news:C2427962-5283-43FD-B9B0-5B367EA2470A@microso...

?-Change data series range as data is entered?
I have a chart which shows a prediction curve and an actual curve. The prediction curve runs out until the end of a project. The actual curve is populated as data is entered. I will be generating a number of these charts from a datatable. I would like to plot the prediction curve for the duration of the project (easy). I would then like to plot the actual curve with only the existing data and not have the line drop to the x-axis at the end. Can I put a formula in the data series "x values" field? I hope that my description makes sense..... Thanks, Carl -- isofuncurves ---...

missing toolbar in Word's Help screen
Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Power PC When I try to access the Help system from Word 2008 (or Excel, for that matter), there is no toolbar at the top of the Help screen--there's no Search box, Topics, Back/Forward, Home, or Print buttons. The PowerPoint Help screen, on the other hand, does have its toolbar. I'm on a Mac PowerPC G4 running OS 10.4.11. <br><br>How can I make the toolbar available for Word's and Excel's Help screens? Click the oblong button at the right end of the Help window's Title Bar. HTH |:>) ...

how to configure multiple email id's in multiple folders
Try posting your Q in the body, and explain what you are trying to achive, together with your version of OL and if its an exchange setup "Ram" <Ram@discussions.microsoft.com> wrote in message news:D0E40903-7D84-49F2-9F91-F97EAB741806@microsoft.com... > ...

Why does Outlook's message recall feature work sometimes but not all the time?
Basically my users have a problem with message recall. The problem is sometimes it works but most of the time it doesn't. Even more frustrating is when they get a successful recall notification message and then they get a reply to the message that was supposedly recalled successfully! Can anyone give me a straight answer or point me in the direction of a reliable article on message recall. www.winnetmag.com has an article that you have to pay for and Microsoft just explains how to use it. Thanks in advance, Chet Senior Customer Support Specialist Message recall is really unr...

Select subform's query criteria from form's unbound cbo
I want users to be able to select a name from a form's unbound combo box and that selection to automatically become the criteria for the subform's underlying query, without the parameter box for the query popping up. How do I do this? I'm new to VBA and not an Access 2003 whiz either. TIA for your help! WorkerBee wrote: > I want users to be able to select a name from a form's unbound combo > box and that selection to automatically become the criteria for the > subform's underlying query, without the parameter box for the query > popping up. How do I do t...

Print bcc's on copy of sent message?
If *I* send a message and blind copy someone on it, is there any way to get Outlook to print the bcc recipients? Right now I'm having to handwrite the bcc's on my file copy. Would love it if Outlook would automatically print this. ...

entering numbers that begin with zero
I often enter manufacturer model#'s into my spreadsheet. If they begin with zero Excel automatically the zero. What can I do to change this? On Sep 10, 1:15=A0pm, Shannon <Shan...@discussions.microsoft.com> wrote: > I often enter manufacturer model#'s into my spreadsheet. =A0If they begin= with > zero Excel automatically the zero. =A0What can I do to change this? You can format the cells to accept leading zero's. From the format cells window, look for custom number formats, then in the Type field type 0000 , with each zero representing the number of digits you w...

What's the Difference Between This NG and microsoft.public.excel.misc?
See Subject. -- W. eWatson (121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time) Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet Web Page: <www.speckledwithstars.net/> Hi, You are posting to the microsoft.public.excel so I'm not sure what you mean by the subject line? your's ends in .m which I don't think is a legal site. The microsoft Excel newgroup area has many sub-areas dealing with: Functions General Questions New users Charts Excel Application Errors Programming ...

Can you import PO's
Does anyone imort Purchase Orders directly from NAV or any other system and if so how are you doing it? Thanks Gaz wrote: > Does anyone imort Purchase Orders directly from NAV or any other system and > if so how are you doing it? > Thanks You can import from NAV through SQL or C/ODBC driver (if you use navision databases).. or using tool how ls retail data director.. cod Gaz, We have a utility to import to a blank PO from CSV file. If you can extract from your other system. May be a solution. http://www.retail-pos.com/addons/csv.html "Gaz" <Gaz@discussions.micr...

e2k3 rus pointing to wrong dc's
is there a way to select which dc the rus uses? sorry...reposted. gave me an error the first time ...

Logo's in Publisher
I have Windows ME and Publisher 2002 Hi. when I download a logo that is sent to me or boarder art I download, I insert it in my publisher doc and it always has a white box backroud. As if I put a fill color in it. I can't seem to just get the words to show up w/out this white backround. I am trying to make a drink menu for a restaurant and every time someone sends me a logo it has that white backround. I've tried jpg, bit and gif and it still does it. Any ideas????? "ChristyLiv" <ChristyLiv@discussions.microsoft.com> wrote in message news:727C0592-E139-...

How do you turn Hyperlink on if it's greyed out?
I have a workbook in which I have created many hyperlinks. All of the sudden the hyperlink key is greyed out and I cant hyperlink anymore. How can I turn it back on. Thank You Is the sheet protected? Regards, Peo Sjoblom "Dan" wrote: > I have a workbook in which I have created many hyperlinks. All of the sudden > the hyperlink key is greyed out and I cant hyperlink anymore. How can I turn > it back on. > > Thank You ...

Excel does not display entered values correctly
I am currently running Excel 2000 on WinXP Pro. Excel does not display the correct values in cells when they are typed. The program arbitrarily assigns a decimal value to whatever number is typed. For example, if "1111111111" is entered, it is displayed as "11111.11111" I have gone through cell formatting, detect and repair and other options, but none have worked. The program use to work fine. It started this recently and it won't go away. If it helps, when a number is typed in another program, i.e. notepad, and copied and pasted into Excel the value displ...

Emailing MP3's
I emailed an MP3 file to a person recently and it was received as a TMP file. I tried sending other files to him and all were received with filenames like ATT177.TMP, ATT178.TMP, etc. When he changes the extension to MP3 the file plays normally. How is the filename being changed and what is the source of this change, the sending or receiving computer? I'm sending via Outlook 2000 and he also has Outlook 2000. -- "Bob Davis" <nospam@nospam.net> wrote in message news:44ALi.63473$hP1.33594@newsfe13.lga... >I emailed an MP3 file to a person recently and it was ...

POS 2.0
I am opening another store and want to copy the products etc. to the new store's POS system. What is the best way of doing it? 1. Backup the existing DB and then restore it on the new store, then clear the transactions 2. Export the inventory in the existing system and import it into the new one 3. ... Please advice, Thank you, -D hi Dursun, Yes you describe the correct way like backup the existing db of the store and restore it to new store and then on the new store delete all the transaction there is button in Store Administrator program. Now there is matter of quantity which ...

Global Address List (It's not displayed)
Hi WHEN I CLICK ON "TO" OR "CC" I GET A MESSAGE SAYING "THE ADDRESS LIST COULD NOT BE DISPLAYED. THE OPERATION CANNOT BE PERFORMED BECAUSE THE CONNECTION TO THE SERVER IS OFFLINE." What could i do ?? Thanks Hi Johan, did you work with Exchange? Or only with a lokal Profile? -- Ich habe nichts gemacht, gestern gings noch! Bitte in den Newsgroup antworten damit jeder etwas davon hat. Bravestar@Datenschutzministerium.de "Johan" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag news:2cf6c01c469be$c0d00ee0$a501280a@phx.gbl... > Hi ...

Here's Your Fre*e Gift of Fortune Creating Software...
RE: Cash Secrets Reports & Software Fre*e... Hi there, That's right, you rea*d correctly; I am giving you Several fre*e super-profit building reports and Software programs! Why am I doing that you are asking? The reason is Simple, because I want to Attract your attention to the kind of quality And service I'm willing to provide you with so You can truly profit in the lucrative business Of Internet marke*ting programs. When you click the link below, you will first be Sent to a signup page. You must provide at least Your first and last name, your email a*ddress And phone numbe...

Let's exchange contact info #3
Hi, Goran Thisell here, how are you? I am putting together a contact list of individuals interested in sharing resources and business information. If you are interested in connecting please send your Name and information to: mailto:coghem@telia.com?subject=BUSINESS_CONTACT_NG I will follow up as soon as I get your email. It's not an autoresponder so it might not be right away. I appreciate your patience. I look forward to meeting you. Regards, Goran Thisell coghem@telia.com --- MAF Anti-Spam ID: 20040306105317O0d3ZyV4 ...

"Failed to save the rule to the user's mailbox"
There's nothing like being blessed with a problem during a Client's deployment. But there's always a wrinkle. In this case MSFT MBS Support has a nice KB for the issue. https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYLSVQUSPTNTNSMQPYXTWZSXKKVXMPOUPXKZZRYZMOSLUMMTOL But it does not cover the situation I have now. It seems that the Exchange administrator configures his user names as "Joe.Carlsbad". Running the query: Select DomainName from systemuserbase shows that there is not a user with the FQDN of the domain. But I did see one successfu...

Microsoft Word's language settings... a bug.
One day, when I was doing Spanish homework on Microsoft Word, I set the language to Spanish to see if I spelled anything wrong. When I finished, I exited out and came back a day later to open up Word. When I typed in my name, I went to this path: Review -> Set Language ....and then I found that for some reason the default language was Spanish, even though I did not say for it to be the default language. So, I set the default to English, and then everything seemed fine. BUT, when I came back again the following day, the default language was Spanish again! The weird thing ...