Drive letter still there but says not formatted now
Weird. D: appears to be still there but when I click on it, it says drive is unformatted, do you want to format? Any ideas how to fix this? If I do choose to format, what are the chances of recovering files that were on there before format?
|
0 |
|
BertieBigBollox
5/4/2010 2:49:37 PM
windowsxp.general
3897 articles. 
1 followers.
8 Replies
542 Views
How about a little background, sparky? If you format you'll lose everything on it. -- "Don't pick a fight with an old man. If he is too old to fight, he'll just kill you." "BertieBigBollox@gmail.com" <bertiebigbollox@gmail.com> wrote in message news:2a7b5fef-ca36-489b-ab7e-cfc96cd7f1ae@24g2000yqy.googlegroups.com... > Weird. D: appears to be still there but when I click on it, it says > drive is unformatted, do you want to format? > > Any ideas how to fix this? If I do choose to format, what are the > chances of recovering files that were on there before format?
|
|
0 |
|
Michael
5/4/2010 4:08:40 PM
BertieBigBollox@gmail.com wrote: > Weird. D: appears to be still there but when I click on it, it says > drive is unformatted, do you want to format? > > Any ideas how to fix this? If I do choose to format, what are the > chances of recovering files that were on there before format? I suspect that the drive is shown as a "RAW" drive, usually a sign of boot sector damage or incorrect partition type in the MBR. Recovery utilities usually handle this problem quite well. See here: http://www.z-a-recovery.com/art-raw-filesystem.htm You could also try TestDisk and see if it can recover the drive. John
|
|
0 |
|
John
5/4/2010 4:19:42 PM
BertieBigBollox@gmail.com wrote:
> Weird. D: appears to be still there but when I click on it, it says
> drive is unformatted, do you want to format?
>
> Any ideas how to fix this? If I do choose to format, what are the
> chances of recovering files that were on there before format?
Well, formatting isn't going to be helping you, and can only
harm the data. So don't do that.
Use a data recovery program, to try to get your files back.
Make sure you have enough space, on some other hard drive, to
write the recovered files. Don't try to write the files
onto the existing, damaged drive. Data recovery programs
only do read operations on the damaged disk, and should be
doing any writes to space you're providing on another hard
drive.
If you want a freebie to try, this is supposed to rescue files
from NTFS. At least one other poster, managed to get files back
from an NTFS partition. Plug in a drive with some space on it
(like an external USB hard drive), so you'll have room to store
the files.
http://www.pricelesswarehome.org/WoundedMoon/win32/driverescue19d.html
Once all your files are safe, you can worry about formatting,
reinstalling, or any other kinds of destructive operations.
While doing those things, make sure your new USB external drive,
has been "Safely Removed" and shut off. (Use the "Safely Remove" icon
in the tray, to flush the cache on the drive.) When you're ready, you can
move the files back, for any files important enough to keep.
With regard to tools such as chkdsk. Chkdsk is a "repair in place" tool
That means, it makes changes to the drive, which could either be a
positive or a negative thing. For example, repair programs can
actually make things worse, in the process of making repairs. That
is because they lack human judgment. For example, if a human saw
a certain pattern of damage, they might stop all repair work, concluding
there are mechanical or electrical problems. A program like chkdsk,
may do more harm than good. If your intention is to use "repair in place"
tools, then doing a sector by sector backup of the damaged drive is a
good idea. A sector by sector backup, doesn't need a working file system,
to do its job. I do these, using a port of "dd", or boot a Linux LiveCD
and use a copy of "dd" there, to copy the damaged disk.
With my approach, you can see why I might recommend the purchase of two
spare drives. One drive contains the sector by sector backup. The other
drive might hold any recovered files. It all depends on whether your
tools are "repair in place" type, or "scavengers". If the files are valuable
to you, then they're worth buying a couple spare drives. Once you own the
spare drives, they can also be used for regular backups.
Chkdsk can attempt to repair a partition. Normally, you feed it a drive
letter, and let it run. If you still have a working drive letter, that
might work. (Of course, on your next reboot, the drive letter could
disappear for good. So don't depend on that letter to stay there.)
Chkdsk can also take a pointer to a "raw partition", but you still need
an identifier to tell it what you want repaired. There are more details here.
They use "mountvol" to get the identifier.
http://technet.microsoft.com/en-us/library/bb457122.aspx
chkdsk \\?\Volume{2d9bd2a8-5df8-11d2-bdaa-000000000000}
In the data recovery business, never assume your difficult situation
is stable. For example, on the very next reboot, you could lose access
to the drive entirely. So your first priority, is to "not panic", and
prioritize the things you do next, in some kind of order. For example,
if you get the sector by sector backup to work, then even if the drive
suffers hardware failure, your data is not lost. It will be much cheaper,
to take your sector by sector backup to a local IT specialist and have
the data restored, than it would be to have to send a broken drive
to a place that recovers data from dead drives. (It is easy to copy
the sector by sector backup, to another drive, but whatever is wrong
with the file system in there, still would need to be fixed.)
To give an example, one night, I had something strange happen to a drive.
(Could hear "clicking and whirring", from the drive doing restarts.)
But I was tired and decided to shut off the computer and worry about it
the next day. When I turned on the computer the next day, the drive and
the data were gone for good. If I'd put the effort into it, at that
point in time, I might have been able to keep the data.
HTH,
Paul
|
|
0 |
|
Paul
5/4/2010 4:28:34 PM
http://technet.microsoft.com/en-us/library/bb457122.aspx -- Peter Please Reply to Newsgroup for the benefit of others Requests for assistance by email can not and will not be acknowledged. http://www.microsoft.com/protect "BertieBigBollox@gmail.com" <bertiebigbollox@gmail.com> wrote in message news:2a7b5fef-ca36-489b-ab7e-cfc96cd7f1ae@24g2000yqy.googlegroups.com... > Weird. D: appears to be still there but when I click on it, it says > drive is unformatted, do you want to format? > > Any ideas how to fix this? If I do choose to format, what are the > chances of recovering files that were on there before format?
|
|
0 |
|
Peter
5/4/2010 5:10:26 PM
On 05/04/10 10:49 am, BertieBigBollox@gmail.com wrote: > Weird. D: appears to be still there but when I click on it, it says > drive is unformatted, do you want to format? > > Any ideas how to fix this? If I do choose to format, what are the > chances of recovering files that were on there before format? I had this problem on one machine with floppies and USB drives that were readable on other machines. The only way I could find to solve the problem was to reinstall the OS. Perce
|
|
0 |
|
Percival
5/4/2010 6:22:22 PM
On Tue, 4 May 2010 07:49:37 -0700 (PDT), "BertieBigBollox@gmail.com" <bertiebigbollox@gmail.com>wrote: >Weird. D: appears to be still there but when I click on it, it says >drive is unformatted, do you want to format? > >Any ideas how to fix this? If I do choose to format, what are the >chances of recovering files that were on there before format? CALLING DAN C. CALLING DAN C. !!!
|
|
0 |
|
Meat
5/4/2010 8:03:48 PM
BertieBigBollox@gmail.com wrote: > Weird. D: appears to be still there but when I click on it, it says > drive is unformatted, do you want to format? > > Any ideas how to fix this? If I do choose to format, what are the > chances of recovering files that were on there before format? You maybe could use a live linix cd and drag the files to the working drive if it shows them intact.
|
|
0 |
|
thedockson
5/8/2010 8:50:17 AM
On May 4, 5:19=A0pm, John John - MVP <audetw...@nbnet.nb.ca> wrote: > BertieBigBol...@gmail.com wrote: > > Weird. D: appears to be still there but when I click on it, it says > > drive is unformatted, do you want to format? > > > Any ideas how to fix this? If I do choose to format, what are the > > chances of recovering files that were on there before format? > > I suspect that the drive is shown as a "RAW" drive, usually a sign of > boot sector damage or incorrect partition type in the MBR. =A0Recovery > utilities usually handle this problem quite well. =A0See here:http://www.= z-a-recovery.com/art-raw-filesystem.htm=A0You could also try > TestDisk and see if it can recover the drive. > > John Tried TestDisk but didnt fix the problem...
|
|
0 |
|
BertieBigBollox
5/10/2010 8:29:13 AM
Similar Artilces:
how to format :send picture with message: as a default
each time i sent a graphic i must go to the format and click "send picture with message." how do I make this a default so it is there permanently.I am running on a Windows XP and am using Outlook Express for my mail. LYNNY <LYNNY@discussions.microsoft.com> wrote: > each time i sent a graphic i must go to the format and click "send > picture with message." how do I make this a default so it is there > permanently.I am running on a Windows XP and am using Outlook Express > for my mail. Ask in an Outlook Express newsgroup. -- Brian Tillman ...
Exchange 2003 installed SP2 now IMF is not working.
I had Exchange 2003 SP1 and installed the IMF. I heard that SP2 has the IMF bulit-in. During the SP2 install it said I had to uninstalled the old IMF, which I did. I then installed Exchange 2003 SP2, I see the tabs in the "System Manager", Global Settings, "Message Delivery" But no IMF portion under the SMTP. I tried to reinstalled the IMF but still it doesn't show up under the SMTP protocals. What am I doing wrong? Within system manager, go to protocols|smtp and select Properties, the Advanced button and then the edit button. Then select the checkbox for en...
FORMATING COLUMNS..... HELP
I need to format columns to allow only 7 characters and the rest of the data to go into column B -- JTEFUN "JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com... >I need to format columns to allow only 7 characters and the rest of the >data > to go into column B > -- > JTEFUN > If you mean that if a user types a lot of data into the one cell and that when they reach 7 characters the rest of the data is automatically inserted into the next cell, then I don't think you can do that....
DPM 2010 standalone tape drives
I have a two drive seagate dat72 device that I am trying to configure to span both drives for a protection group. I think that the problem is that they are seen as two seperate libraries (standalone drives) Is there any way to span these two devices with a single protection group? Thanks, DPM 2010 Ken On May 5, 11:43=A0am, Ken <kgare...@gmail.com> wrote: > I have a two drive seagate dat72 device that I am trying to configure > to span both drives for a protection group. > I think that the problem is that they are seen as two seperate > libraries (standal...
IBF for Microsoft CRM now available
Great news to pass along. After a much longer wait than anyone imagined, our IBF solution for Microsoft CRM is now available. It took us a ton of work to get the performance and security of this solution right, but I think you'll find it's well worth the wait! The number of new scenarios enabled and the ability to access Microsoft CRM data from directly inside of your favorite Microsoft Office applications is really compelling. You can download the solution from: http://www.microsoft.com/downloads/details.aspx?FamilyId=332BEFFB-4492-40D7-8CE0-995489909B6A&displaylang=en Join me...
BULK Conditional Formatting
I've read the posts on conditional formatting for cell colour based o another cell's value (eg. set the conditional formatting to "formul is" and then "=A1>0" and set the colour as red / blue / whatever...) however wondering if I can do this for an entire column withou individually changing the conditional formatting for each cell one b one (as there are over 400 rows). Basically I need a formula that reads the contents of column B for th particular row that is active. Can anyone help -- Rob Moyl ---------------------------------------------------------------...
Still recieving e-mail for deleted users
We are receiving e-mails for users that were been deleted from our server years ago. Does anyone know how to block these e-mails. We have a SPAM program that allows you to blacklist but it does not stop the messages from coming through. Create ea distribution list containing no members, but which has all the long-gone users' smtp addresses. This is called a blackhole DL. Exchange will accept the mail but silently drop it - no NDRs, no storage. -- hth, SusanV "RB" <pr@epley-pr.com> wrote in message news:574a01c40071$05a154a0$a501280a@phx.gbl... > We are receiving...
Drawing letters
Hey I am trying to find a way to draw the word LOOP in a way so thar the letters apears as if they are bend from a long rod or so. It is my hope to be able to draw the letters so the letters "OO" mekes a "loop" and still be connectet to the starting letter "L" and the last letter "P" English is not my mative laungish so please forgive any misspells ;o) Can any please help? Im using Publisher CS -- Med venlig hilsen John http://www.dkfritidmotorcykel.dk/?id=1071 I forgot to write that it has to appear as 3D -- Best regards John http://www.dkfr...
columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and forumlas now look like =RC[-1]*R[-3]C[6] I was trying to make the R[-3]C[6] static (using the $) but it errors. Thanks Mike In Excel Options uncheck "R1C1 Reference Style" Gord Dibben MS Excel MVP On Thu, 28 Oct 2010 20:25:30 -0400, Mike <no_please@not.com> wrote: >I noticed my excel clumns have changed from letters to numbers and >forumlas now look like =RC[-1]*R[-3]C[6] >I was trying to make the R[-3]C[6] static (using the $) but it errors. >Thanks >Mike ...
Format Problem
I have a report of a crosstab query. I formatted the left column of the report with Text Align set to Right. The report is chopping off the last character of the term, even if I set the Right Margin to 0.5". Doing so just puts space between the right edge of the border and the end of the chopped word I have played with all of the format settings in the properties with no success. If I set Text Align to Left the word is not chopped, but I would prefer Text Align set to right. Is there a way to fix this format issue with Text Align set to the Right? -- Message posted via http://www.acce...
Conditional Statements and Time Format
Hello, I have a spreadsheet where I need to calculate a range of time in a cell and display a value in another cell. Example is in cell F2 I have a time displayed of 15:34, and in the calculation window it displays as 3:34:00 PM. In Cell F3 I want to display one of three things, "1st shift", "2nd shift" or "3rd shift". Is it possible to use the conditional statements to give me the value of "1st shift" when cell F2 is between >= 07:00 and < 15:00? I can't find anything that speaks to getting thee range information from time. Thanks, Brian ...
Rich Text formatting in Access 2007
In Access 2007, is it possible to add rich text formatting to text in a memo field (or mixed formatting within any text field). I have just upgraded to the new version of Access, and it appears that this feature still has not been added. Is this correct? (If so, why?) If it is not possible to format individual words within a field in Access, , is there a simple, free add-in that will enable Access to do this kind of basic formatting, such as adding italic, bold, and underlining? Thanks very much for any information you may have. Bob Rich Text format for Memos in: Tables - Look in t...
formatting cell in vlookup
HELP I have an excel spreadsheet that is e:mailed to me by my home office. I use the vlookup feature to find the value in cell b from the information in a Proble At times when the answer is N/A and I go to the e:mailed spreadsheet to see if that number is really not there, it is in the e;mailed spreadsheet. If I type over that number in the cell on the e;mailed spreadsheet, then the formula will work in the target spreadsheet, sometimes This e;mailed spreadsheet is at a shared location on a servier, and the items I fix in the e;mailed spreadsheet on my desk top, are not available in any ...
Copy a formula formatted as Text In Excel
I have a UDF that returns the formula of a given cell in a text format. Is there anyway to have excel recognize that the result of the function is a formula and not text. Once I click on the cell, hit F2 to edit it and then enter, Excel realizes it's a formula and then calculates the value, Nope. The formula in the cell is going to be the UDF--not the what formula string looks like. You could add some more steps. Select the range (if more than one cell) Convert to values (edit|copy, edit|paste special|values) and finally edit|replace what: = (equal sign) with: = replace all And exce...
Upgraded Vista -Win7 now crashing Outlook 2003
Hi Q 1 I upgraded from Vista to Windows 7 and receive regular updates from MS. Since the upgrade when I open Outlook 2003 it starts downloading emails and ½ way through it crashes. additionally my email rules frequently dont work - typically I need to run - detect and repair a few x [restore my shortcuts while restoring]. How do i fix this? Q 2 Re: The other option 'Discard my custom settings and restore default settings" - I'm not clear on what this is - i cant seem to find detailed information on this..... if this is a solution i would need to save and ...
Formatting and loss of emails/contacts/etc?
Hi folks, Have to format and reinstall everything ... XP PRO/OFFICE 02 PRO ... I have emails/contacts/etc that I would like to be able take with me when I reinstall ... I can save copies of Excel/Word files to another hardrive. Is there a painless way of saving Outlook email/contact/etc files? Thanks in advance, Debbie The file you need to back up is your Personal Folders file (*.pst) It's where all the mail, calendar, contacts etc are stored. Just copy and reuse this file after you reformat. Take a look at these pages for info on Outlook data backup: http://www.slipstick.com/c...
Custom or conditional format to highlight today's date?
Using Excel 2002, I have all 365 days of the year listed in column B, formatted as "03/14/01". When i open the workbook, I would like the current date to be bold and red. Can I do this with a conditional format? I have tried =Today with no success. Thanks Tonso "Tonso" <wthomasss@hotmail.com> wrote in message news:13885af2-777c-43ff-9684-1b5bda8d95d6@o6g2000yql.googlegroups.com... > Using Excel 2002, I have all 365 days of the year listed in column B, > formatted as "03/14/01". When i open the workbook, I would like the > current date to b...
Font Format
I have merged two different sets of data where one sheet has names in all caps and the other not in all caps. When I'm doing a pivot table, it is using the names as two different values. There is no option in the font format to make the non-cap names into all caps. How can I make the font all consistent so that it is not appearing as two different values. Thanks! "mira" <mira@discussions.microsoft.com> wrote in message news:6A30BAA4-8640-47C2-8B7F-9B777A6A66D6@microsoft.com... >I have merged two different sets of data where one sheet has names in all > caps...
Formatting Numbers to Text or??!!!
I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2...
What's the best format for pictures used in Publisher?
This thread suggests PNG is the preferred format: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.publisher.prepress&tid=a70b836f-f21b-44c1-a361-66ba89766785&cat=&lang=en&cr=US&sloc=&p=1 What's the best format? 1. TIFF 2. PNG 3. JPG Also, is it better to LINK the picture or EMBED the picture? Mr. Analogy wrote: > What's the best format? > 1. TIFF > 2. PNG > 3. JPG PNG is best for non-photographic data or data that need to be modified many times. JPEG is a good format for photographic data that is not modified...
Mail Merge Date Format Problem
Trying to merge in data from an Excel spreadsheet but when the date goes in, it is in US format rather than english format, i.e 08/31/04 rather than 31/08/04. Tried changing the format in Excel first which doesn't work and my PC is set up with UK date as standard. Any ideas how I can change it? Cheers Nick Hi Nick (anonymous@discussions.microsoft.com), in the newsgroups you posted: || Trying to merge in data from an Excel spreadsheet but when || the date goes in, it is in US format rather than english || format, i.e 08/31/04 rather than 31/08/04. Tried changing || the format in E...
ANN: Visual XSLT 2.0 Beta 1 is now available
Visual XSLT is a plug-in for Microsoft Visual Studio .Net that offers full-featured editing and debugging of XSLT files. The two major additional features for version 2.0 are the following: A "just-in-time" debugger, that lets you debug .Net XSLT Transforms that are embedded in other applications (even if you don't have the source for the application source code, XSLT, or XML). You tell Visual XSLT which application to run, and when it reaches a call to System.Xml.Xsl.Transform, the XSLT debugger comes to the foreground. A Visual "schema mapper". Build two trees, b...
cell format #9
I have a spreadsheet that is used to track cases in a legal clinic. One of the cells tends to get fairly large and it seems that once you reach a certain point, you can still add to it, but it will not display in the cell any longer. It looks as if it stops wrapping to fit the cell. When the cell is highlighted, you can see the entire text in the formula bar, but it does not appear in the cell. Is there a way to eliminate a limit on text in any given cell? Hi there's a limit of a max of 1204 characters per cell. You can extend this limit if you manually insert some linebreaks with ...
Chart Source Data Formats
We currenlty use Excel Charts where the Source Data is linked to anothe workbook. The Number Formats are not carried over correctly from thi Workbook unless both Workbooks are open at the same time-however th values are not affected by this and do not require the other Workboo to be open. We need to be able to E-Mail the Charts with the correct Number Format without needing to open both Workbooks as the recipients will not hav access to the Workbook containing the Source Data as this contain other confidential information. The version of Excel we are using is Microsoft Excel 2003. Any help or...
9 months later still have error 12110
Hi, I posted this about 9 months and have never resolved my problem. I maintain a web page using FrontPage 2000 on my Windows Vista Home Premium computer. When I go to publish my changes I get the following error: 12110 ERROR_FTP_TRANSFER_IN_PROGRESS The requested operation cannot be made on the FTP session handle because an operation is already in progress. If I close the error message and click on Publish again and repeat the process over and over the update will finally work. Last time I was referred to various pages at Microsoft and jumped ...
each time i sent a graphic i must go to the format and click "send picture with message." how do I make this a default so it is there permanently.I am running on a Windows XP and am using Outlook Express for my mail. LYNNY <LYNNY@discussions.microsoft.com> wrote: > each time i sent a graphic i must go to the format and click "send > picture with message." how do I make this a default so it is there > permanently.I am running on a Windows XP and am using Outlook Express > for my mail. Ask in an Outlook Express newsgroup. -- Brian Tillman ...
Exchange 2003 installed SP2 now IMF is not working.
I had Exchange 2003 SP1 and installed the IMF. I heard that SP2 has the IMF bulit-in. During the SP2 install it said I had to uninstalled the old IMF, which I did. I then installed Exchange 2003 SP2, I see the tabs in the "System Manager", Global Settings, "Message Delivery" But no IMF portion under the SMTP. I tried to reinstalled the IMF but still it doesn't show up under the SMTP protocals. What am I doing wrong? Within system manager, go to protocols|smtp and select Properties, the Advanced button and then the edit button. Then select the checkbox for en...
FORMATING COLUMNS..... HELP
I need to format columns to allow only 7 characters and the rest of the data to go into column B -- JTEFUN "JTEFUN" <JTEFUN@discussions.microsoft.com> wrote in message news:6C5C7A99-E83F-430E-9576-6D1DB57B9311@microsoft.com... >I need to format columns to allow only 7 characters and the rest of the >data > to go into column B > -- > JTEFUN > If you mean that if a user types a lot of data into the one cell and that when they reach 7 characters the rest of the data is automatically inserted into the next cell, then I don't think you can do that....
DPM 2010 standalone tape drives
I have a two drive seagate dat72 device that I am trying to configure to span both drives for a protection group. I think that the problem is that they are seen as two seperate libraries (standalone drives) Is there any way to span these two devices with a single protection group? Thanks, DPM 2010 Ken On May 5, 11:43=A0am, Ken <kgare...@gmail.com> wrote: > I have a two drive seagate dat72 device that I am trying to configure > to span both drives for a protection group. > I think that the problem is that they are seen as two seperate > libraries (standal...
IBF for Microsoft CRM now available
Great news to pass along. After a much longer wait than anyone imagined, our IBF solution for Microsoft CRM is now available. It took us a ton of work to get the performance and security of this solution right, but I think you'll find it's well worth the wait! The number of new scenarios enabled and the ability to access Microsoft CRM data from directly inside of your favorite Microsoft Office applications is really compelling. You can download the solution from: http://www.microsoft.com/downloads/details.aspx?FamilyId=332BEFFB-4492-40D7-8CE0-995489909B6A&displaylang=en Join me...
BULK Conditional Formatting
I've read the posts on conditional formatting for cell colour based o another cell's value (eg. set the conditional formatting to "formul is" and then "=A1>0" and set the colour as red / blue / whatever...) however wondering if I can do this for an entire column withou individually changing the conditional formatting for each cell one b one (as there are over 400 rows). Basically I need a formula that reads the contents of column B for th particular row that is active. Can anyone help -- Rob Moyl ---------------------------------------------------------------...
Still recieving e-mail for deleted users
We are receiving e-mails for users that were been deleted from our server years ago. Does anyone know how to block these e-mails. We have a SPAM program that allows you to blacklist but it does not stop the messages from coming through. Create ea distribution list containing no members, but which has all the long-gone users' smtp addresses. This is called a blackhole DL. Exchange will accept the mail but silently drop it - no NDRs, no storage. -- hth, SusanV "RB" <pr@epley-pr.com> wrote in message news:574a01c40071$05a154a0$a501280a@phx.gbl... > We are receiving...
Drawing letters
Hey I am trying to find a way to draw the word LOOP in a way so thar the letters apears as if they are bend from a long rod or so. It is my hope to be able to draw the letters so the letters "OO" mekes a "loop" and still be connectet to the starting letter "L" and the last letter "P" English is not my mative laungish so please forgive any misspells ;o) Can any please help? Im using Publisher CS -- Med venlig hilsen John http://www.dkfritidmotorcykel.dk/?id=1071 I forgot to write that it has to appear as 3D -- Best regards John http://www.dkfr...
columns changed to numbers instead of letters?
I noticed my excel clumns have changed from letters to numbers and forumlas now look like =RC[-1]*R[-3]C[6] I was trying to make the R[-3]C[6] static (using the $) but it errors. Thanks Mike In Excel Options uncheck "R1C1 Reference Style" Gord Dibben MS Excel MVP On Thu, 28 Oct 2010 20:25:30 -0400, Mike <no_please@not.com> wrote: >I noticed my excel clumns have changed from letters to numbers and >forumlas now look like =RC[-1]*R[-3]C[6] >I was trying to make the R[-3]C[6] static (using the $) but it errors. >Thanks >Mike ...
Format Problem
I have a report of a crosstab query. I formatted the left column of the report with Text Align set to Right. The report is chopping off the last character of the term, even if I set the Right Margin to 0.5". Doing so just puts space between the right edge of the border and the end of the chopped word I have played with all of the format settings in the properties with no success. If I set Text Align to Left the word is not chopped, but I would prefer Text Align set to right. Is there a way to fix this format issue with Text Align set to the Right? -- Message posted via http://www.acce...
Conditional Statements and Time Format
Hello, I have a spreadsheet where I need to calculate a range of time in a cell and display a value in another cell. Example is in cell F2 I have a time displayed of 15:34, and in the calculation window it displays as 3:34:00 PM. In Cell F3 I want to display one of three things, "1st shift", "2nd shift" or "3rd shift". Is it possible to use the conditional statements to give me the value of "1st shift" when cell F2 is between >= 07:00 and < 15:00? I can't find anything that speaks to getting thee range information from time. Thanks, Brian ...
Rich Text formatting in Access 2007
In Access 2007, is it possible to add rich text formatting to text in a memo field (or mixed formatting within any text field). I have just upgraded to the new version of Access, and it appears that this feature still has not been added. Is this correct? (If so, why?) If it is not possible to format individual words within a field in Access, , is there a simple, free add-in that will enable Access to do this kind of basic formatting, such as adding italic, bold, and underlining? Thanks very much for any information you may have. Bob Rich Text format for Memos in: Tables - Look in t...
formatting cell in vlookup
HELP I have an excel spreadsheet that is e:mailed to me by my home office. I use the vlookup feature to find the value in cell b from the information in a Proble At times when the answer is N/A and I go to the e:mailed spreadsheet to see if that number is really not there, it is in the e;mailed spreadsheet. If I type over that number in the cell on the e;mailed spreadsheet, then the formula will work in the target spreadsheet, sometimes This e;mailed spreadsheet is at a shared location on a servier, and the items I fix in the e;mailed spreadsheet on my desk top, are not available in any ...
Copy a formula formatted as Text In Excel
I have a UDF that returns the formula of a given cell in a text format. Is there anyway to have excel recognize that the result of the function is a formula and not text. Once I click on the cell, hit F2 to edit it and then enter, Excel realizes it's a formula and then calculates the value, Nope. The formula in the cell is going to be the UDF--not the what formula string looks like. You could add some more steps. Select the range (if more than one cell) Convert to values (edit|copy, edit|paste special|values) and finally edit|replace what: = (equal sign) with: = replace all And exce...
Upgraded Vista -Win7 now crashing Outlook 2003
Hi Q 1 I upgraded from Vista to Windows 7 and receive regular updates from MS. Since the upgrade when I open Outlook 2003 it starts downloading emails and ½ way through it crashes. additionally my email rules frequently dont work - typically I need to run - detect and repair a few x [restore my shortcuts while restoring]. How do i fix this? Q 2 Re: The other option 'Discard my custom settings and restore default settings" - I'm not clear on what this is - i cant seem to find detailed information on this..... if this is a solution i would need to save and ...
Formatting and loss of emails/contacts/etc?
Hi folks, Have to format and reinstall everything ... XP PRO/OFFICE 02 PRO ... I have emails/contacts/etc that I would like to be able take with me when I reinstall ... I can save copies of Excel/Word files to another hardrive. Is there a painless way of saving Outlook email/contact/etc files? Thanks in advance, Debbie The file you need to back up is your Personal Folders file (*.pst) It's where all the mail, calendar, contacts etc are stored. Just copy and reuse this file after you reformat. Take a look at these pages for info on Outlook data backup: http://www.slipstick.com/c...
Custom or conditional format to highlight today's date?
Using Excel 2002, I have all 365 days of the year listed in column B, formatted as "03/14/01". When i open the workbook, I would like the current date to be bold and red. Can I do this with a conditional format? I have tried =Today with no success. Thanks Tonso "Tonso" <wthomasss@hotmail.com> wrote in message news:13885af2-777c-43ff-9684-1b5bda8d95d6@o6g2000yql.googlegroups.com... > Using Excel 2002, I have all 365 days of the year listed in column B, > formatted as "03/14/01". When i open the workbook, I would like the > current date to b...
Font Format
I have merged two different sets of data where one sheet has names in all caps and the other not in all caps. When I'm doing a pivot table, it is using the names as two different values. There is no option in the font format to make the non-cap names into all caps. How can I make the font all consistent so that it is not appearing as two different values. Thanks! "mira" <mira@discussions.microsoft.com> wrote in message news:6A30BAA4-8640-47C2-8B7F-9B777A6A66D6@microsoft.com... >I have merged two different sets of data where one sheet has names in all > caps...
Formatting Numbers to Text or??!!!
I have a spreadsheet that contains the following data: Date Account ID 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 5280-3-01 5/14/08 1030-0-01 5/14/08 1030-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 5/14/08 2101-0-01 When I save it as a .csv file it looks like this: Date Account ID 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 3/1/5280 5/14/2008 1030-0-01 5/14/2...
What's the best format for pictures used in Publisher?
This thread suggests PNG is the preferred format: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.publisher.prepress&tid=a70b836f-f21b-44c1-a361-66ba89766785&cat=&lang=en&cr=US&sloc=&p=1 What's the best format? 1. TIFF 2. PNG 3. JPG Also, is it better to LINK the picture or EMBED the picture? Mr. Analogy wrote: > What's the best format? > 1. TIFF > 2. PNG > 3. JPG PNG is best for non-photographic data or data that need to be modified many times. JPEG is a good format for photographic data that is not modified...
Mail Merge Date Format Problem
Trying to merge in data from an Excel spreadsheet but when the date goes in, it is in US format rather than english format, i.e 08/31/04 rather than 31/08/04. Tried changing the format in Excel first which doesn't work and my PC is set up with UK date as standard. Any ideas how I can change it? Cheers Nick Hi Nick (anonymous@discussions.microsoft.com), in the newsgroups you posted: || Trying to merge in data from an Excel spreadsheet but when || the date goes in, it is in US format rather than english || format, i.e 08/31/04 rather than 31/08/04. Tried changing || the format in E...
ANN: Visual XSLT 2.0 Beta 1 is now available
Visual XSLT is a plug-in for Microsoft Visual Studio .Net that offers full-featured editing and debugging of XSLT files. The two major additional features for version 2.0 are the following: A "just-in-time" debugger, that lets you debug .Net XSLT Transforms that are embedded in other applications (even if you don't have the source for the application source code, XSLT, or XML). You tell Visual XSLT which application to run, and when it reaches a call to System.Xml.Xsl.Transform, the XSLT debugger comes to the foreground. A Visual "schema mapper". Build two trees, b...
cell format #9
I have a spreadsheet that is used to track cases in a legal clinic. One of the cells tends to get fairly large and it seems that once you reach a certain point, you can still add to it, but it will not display in the cell any longer. It looks as if it stops wrapping to fit the cell. When the cell is highlighted, you can see the entire text in the formula bar, but it does not appear in the cell. Is there a way to eliminate a limit on text in any given cell? Hi there's a limit of a max of 1204 characters per cell. You can extend this limit if you manually insert some linebreaks with ...
Chart Source Data Formats
We currenlty use Excel Charts where the Source Data is linked to anothe workbook. The Number Formats are not carried over correctly from thi Workbook unless both Workbooks are open at the same time-however th values are not affected by this and do not require the other Workboo to be open. We need to be able to E-Mail the Charts with the correct Number Format without needing to open both Workbooks as the recipients will not hav access to the Workbook containing the Source Data as this contain other confidential information. The version of Excel we are using is Microsoft Excel 2003. Any help or...
9 months later still have error 12110
Hi, I posted this about 9 months and have never resolved my problem. I maintain a web page using FrontPage 2000 on my Windows Vista Home Premium computer. When I go to publish my changes I get the following error: 12110 ERROR_FTP_TRANSFER_IN_PROGRESS The requested operation cannot be made on the FTP session handle because an operation is already in progress. If I close the error message and click on Publish again and repeat the process over and over the update will finally work. Last time I was referred to various pages at Microsoft and jumped ...