Tag Info

New answers tagged

0

As already answered, use: The percentage formatting for the final rendering The data validation for the input restriction BUT: you need to set it up as user defined validation, with a formula like the following, considering D2 is your reference cell: =IF(D2=TRUNC(D2;2);TRUE;FALSE)


1

try this in cmd.exe replace X for the disk number of your USB which is shown when you input list disk diskpart list disk select disk X clean create part pri select part 1 format fs=ntfs quick exit


1

Run the following command: DiskPart List Disk Select Disk YOUR_DRIVE_NUMBER WARNING: Select the correct one which is your USB Clean Create Partition Primary Active Format fs=FAT32 quick Assign Now you should able to see your USB drive in Computer


1

Ctrl + H Click on "More >>" Click on "Special" > "Graphic" Now you can see ^g in "Find what:". Click on "Replace All"


0

Would've loved a more elegant solution on this one. Unfortunately, all merging actions throw the rest of the data out (keeps upper left, top most data only). Not sure if this will help you (or if you still need a solution) but to circumvent this, I saved the file as a CSV, added a place-holder column with ____ as the text, and saved the file, then opened ...


0

to use this answer in word 2011 for MAC, -click anywhere in the document -go to 'view' menu, then select 'outline' view, then 'footnotes' a separate pane opens up at the bottom of the screen, with your footnotes and a drop down menu. In the drop down menu select 'footnote separator' and then delete the massive gap. Thanks for the original post.


0

In Impress, LibreOffice v. 4.4.3.2, saving line-spacing in a PPT-formatted file worked when I used the Line Spacing tool icon: Perhaps the method you're using to add line spacing is not compatible with the PPT format, rather than native ODP format, but the Line Spacing tool format is maintained. Also, you've not mentioned the version of LibreOffice; ...


0

I've had this problem today so thought I'd post an answer in case anyone is still stuck on it. You can get around this by highlighting the cell and then copy and pasting the code directly out of the text bar at the top by clicking in to it and highlighting it all manually. I've only done this in Excel 2010 so I don't know if this will work for earlier ...


0

I got the MicroSD card working again by putting it into a camera and formatting the card there. For some reason that got it re-readable and was able to format it on my computer using a MicroSD to SD adapter. The MicroSD to USB adapter was shoddy and still doesn't work, and I suspect it was what caused the corruption in the first place.


0

under conditional formatting, use the "Use a formula to select which cells to format" option. enter: =AND(NOT(ISBLANK(A*)), A* = "tea") (where A* is the 1st cell in the range you want to format) add a second rule for the same range and enter the formula: =NOT(AND(ISBLANK(A*)) Make sure that the 1st rule (selecting for "tea" is 1st (on top) This will ...


1

It happens if the text exceed 256 characters, hence it shows ######. Some of our friend suggest to change from Text to General, but Excel error may pop up: So, the solution is simple, just begin your text with just adding the ' symbol, in order to neglect any setting of the column, yet you still have to use General Format.


2

Some currency systems require a slightly different comma schema. With data like: applying this Custom Number Format: [>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0 will produce:


0

You can use to live-cd of Gparted and with unetbootin you can write it on a Usb key (Formated in format Fat32) Gparted Link


-1

These are the steps to format your PC: backup the pc make bootable media "usb, hardrive" copy media files to media "operating system" boot from media "usb, hardrive"etc. follow the wizard to format



Top 50 recent answers are included