Questions tagged [formatting]
Process of preparing a disk for storing data. Specifically, "high-level formatting" involves the creation of a new file system and/or a boot sector. For text formatting, use [text-formatting].
1,283
questions
0
votes
0
answers
13
views
My Seagate hard disk shows that's is RAW and also show that is 0 bytes
My Seagate hard disk shows that's is RAW and also show that is 0 bytes and in diskpart it shows that it is healthy, when trying to format to NTFS using diskpart it is stuck on 0%.
0
votes
1
answer
42
views
Does windows ‘reset this pc’ format the drive?
Sorry if this is a stupid question, I tried to find this online but can’t see any answers.
When you use windows ‘reset this pc’ does it format the drive, and does it differ if you select the ‘clean ...
0
votes
1
answer
14
views
Where is the Sparkline tab in the Show group for Excel?
How would I display the high points?
screenshot
Copilot says:
You Apply Blue sparkline color and display the high points for the
sparklines.
Copilot Certainly! Let’s create sparklines in Excel, apply ...
0
votes
1
answer
16
views
How to use conditional formatting based on a different column?
Looking to format a column background color using conditional formatting based on the integer value from a different column. Where or how is the second column referenced?
Bing AI, copilot, says:
...
0
votes
0
answers
21
views
Program shows up in task manager startup list after format [closed]
I recently formatted my system and installed a fresh OS but a program that was installed before format showed up in the startup list in task manager.
I want to understand how this was possible.
I did ...
0
votes
1
answer
37
views
Is it possible to recover files from quickly formatted HDD? [duplicate]
I have formatted my hard drive, now I wonder if it is possible to recover the files while I have reinstalled windows on the same drive and been using it for a few weeks and almost filled the hard ...
0
votes
0
answers
43
views
How to quickly delete files and folders in Windows 10 so that they can never be recovered or accessed again
I have an application and txt files where the records of this application are kept. When I give a command via CMD, I want these files to be quickly deleted, irrecoverable and inaccessible. Depending ...
1
vote
0
answers
76
views
How to format partition of the disk which has System & reserved files?
I wanted to format partition on my SSD, but it has System and reserved files. Does anybody know if I can just delete these files or move them to another disk?
1
vote
1
answer
136
views
How to format Y axis in an Excel chart in days, hours, minutes?
I have an Excel chart tracking time taken to complete a task. I managed to use rows in my spreadsheet to apply custom data labels for the graph, but it doesn't match up to the Y axis of my graph.
I ...
0
votes
2
answers
112
views
Cannot access the SD card after formating on camera
I have a 64GB SD card and a Pentax K7 camera. At some point my camera stopped reading the card, and I formatted in camera's settings. Now, I can take pictures and read them on my camera, but my PC ...
1
vote
1
answer
36
views
Excel conditional formatting highlighting different cells in range
I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have ...
0
votes
2
answers
260
views
Multiple Currency Number Formats in the Same Excel using Custom Number Formatting
I have an excel which has multiple columns of numeric values / amounts, which are all in different currencies in different column. One column is in one currency.
I have my regional setting set to a ...
1
vote
1
answer
310
views
How to remove values in conditional formatting
I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get greyed out. When user selects Yes in Row 1, Row 2 and subsequent ...
0
votes
0
answers
29
views
USB flash not working after PC turned off while formating [duplicate]
So I was using Rufus to put a copy of Windows 10 on a USB flash drive. The power suddenly cut and after the USB flash drive stopped working.
I tried some solutions but they fail, is the damage ...
0
votes
2
answers
99
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
2
votes
1
answer
367
views
How can I zero out only the USED space on a storage drive?
I have a large drive (4TB) that I've only written a few gigabytes to. I'm giving it to a friend, so I'd like to zero it out. I know I can zero out the whole drive with dd, but I'd like to know if:
...
0
votes
1
answer
49
views
Excel - status (online/offline) corresponding to concrete number
I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...
0
votes
0
answers
20
views
Auto Numbering in a single cell
I want a Cell to Auto-populate a Tracking # in a form that several people have access to on a shared drive. Example:
I open the Exception Form for the first time and it should show SL(date)-#:
result ...
0
votes
1
answer
85
views
Convert duration in XXm, YYs format to time value
In Microsot Excel, I have string data that represents duration of an event:
duration
40s
5m, 40s
59m, 59s
I need to convert the values to time (in adjacent column) so that I can format and sort ...
0
votes
0
answers
80
views
Why can't Windows 11 read properly the SSD which I connected to my laptop using a USB connector?
I wanted to wipe an SSD that was previously in a PC with Windows 11. I connected it via USB to my PC and Windows is telling me "A specified device does not exist". I checked it using "...
0
votes
0
answers
20
views
Best practice for repurposing a Windows 10 laptop for a charity [duplicate]
I have several laptops with Windows 10 installed which are BitLocker-encrypted. I am going to gift them to a charity and wondered if it was sufficient to use the in-built "Reset this PC" ...
1
vote
2
answers
1k
views
Formatting of braces for C++ in Visual Studio Code
I've C/C++ extension of Microsoft as my default formatter. When I save/run my code the opening curly braces automatically move to newline instead of staying in sameline. How can I prevent this? (It ...
0
votes
0
answers
48
views
(Microsoft Word) How to stop styles opening in a box?
I'm trying to make some text be in the style of Header 1, Header 2, Header 3, etc
When I change the style of text, it opens up in this box instead of staying normal text that is in line with the rest ...
0
votes
1
answer
72
views
What are options to set up a new portable SSD for newer and legacy Windows computers?
I bought a new 4TB M.2 NVME and an external M.2 enclosure for it. I want to set this up to be used like portable storage (used like "flash" storage), so that it can be used on a new Win 11 ...
0
votes
0
answers
24
views
Cells number format breaks in one column only if multiple cells are moved
I have a table where I keep track of best times & corresponding dates in pairs of cells. Time on top with the date below it, stored in range [B3:E10]. The time values are entered into the formula ...
0
votes
0
answers
197
views
File System Unknown after decryption with Veracrypt Rescue Disk
My laptop had 2 veracrypt (1.25.9) disks (one as system, and the other with the same password) with windows installed in the first disk.
Suddenly it could´t boot anymore (May be it happened because, ...
-1
votes
2
answers
346
views
How to copy/paste cells from a conditionally formatted sheet to another file or sheet with formatting but without conditional rules?
I have an excel file "Book1" with conditional formatting enabled on "Sheet1".
Conditional rules are based on a formula.
For example, highlight the entire row blue if the value in ...
0
votes
1
answer
52
views
How can be column incluted into rows?
There is the table in MS Excel or LO Calc.
How can be it converted to this view of the table?
The transformation using links (within the same table) to the initial version is allowed.
0
votes
0
answers
109
views
ext4lazyinit and forcing to have similar times as an ext4 format time, advantages and disadvangages
I saw this question and while 2 years is a long time, can anybody share anything about any progress on ext4lazyinit. I am specifically interested in this statement by Ted Tso -
So that is what the ...
0
votes
2
answers
131
views
How do I format a target cell based on a source cell, using VBA?
I'm looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.
So for instance: NOT(H) is showing as green in table 1 and I want it to ...
0
votes
0
answers
1k
views
Excel - paste *only* number formatting
Is it possible to copy/paste only number formatting in Excel.
There are various paste special options.
In particular Formulas/Number Formats and Values/Number Formats. But is there a way to paste only ...
0
votes
1
answer
847
views
Fill a cell when empty, and past a date in another column
I need a cell in column "B" to fill red, if it is empty and the date is past the date on column "M"
I have tried googling it, and there are no answers to help.
Thanks for your help
2
votes
0
answers
161
views
Stacked Area Chart Excel, 3 Series Negative Problems
I am trying to create a chart similar to this original chart. I'm having troubles with the negative values. The red area falls negative when I chart it as a stacked chart.
It seems like it should be ...
1
vote
0
answers
60
views
how to find the undesirable formatting in a presentation/slides such as bold or Symbol font
My manager told me he think in some places of my presentation file he noticed inappropriate formats such as bold and Symbol font. Is there an easy way, preferably free like in free beer way to search ...
0
votes
1
answer
89
views
Could I format my C: Drive by mistake?
Could you accidentally reformat a C: drive using file explorer? Would it be remotely possible?
I'm just wondering if this can happen - is it possible to accidentally click the format button on "...
1
vote
1
answer
788
views
How long do it take to fully format USB drive 2TB 2.0?
Since I can't find any answer from the internet, I hope someone will help me here.
I have just bought a 3.5$ USB drive 2TB 2.0. When I transfer my video file to the USB, the 3 first video is working ...
1
vote
2
answers
225
views
My SSD is acting like writing is locked. Not even bash dd command can achieve anything. How may I fix my drive?
I currently am using a 2.5" WD Blue 1Tb SSD for backups. I use Macrium Reflect on Windows to clone my C to it. Last time I attempted the clone, and because I don't do it often enough to remember ...
2
votes
1
answer
444
views
No drive letter assigned to USB, "Device not ready" on initialize attempt
I have a Toshiba 1TB external USB drive that I haven't used in a few years, but I'd like to use it now. Windows detects the USB, but doesn't assign a drive letter when I plug it in, regardless of ...
0
votes
3
answers
190
views
Data Formatting in Microsoft Excel: Cell formatting, Text formatting, and Number Formatting [closed]
Formatting text or numbers can make them appear more visible especially when you have a large worksheet.
Formatting in Excel is a simple process of modifying or manipulating data in spreadsheets from ...
1
vote
0
answers
188
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
0
votes
1
answer
713
views
Remove formatting and partitions on a storage device
Under some circumstances, normal partitioning tools refuse do the requested work;
i.e. removing partitions, and deleting the partition table is troublesome...
How to get past this state? Please ...
0
votes
1
answer
254
views
Is there a way to create persistent bullets in Power Point?
I have added three custom bullets to the Style Master Text placeholder, however, I would like to have a choice to choose one of those three bullets on the fly. These come in a custom font.
This will ...
0
votes
1
answer
77
views
Change to Italic only one symbol in MS Word
I need to find all "ΔE" and change only "E" symbol to italic.
How can it be done by find and replace, because it make both ΔE italic?
Off course it can be done by changing all &...
0
votes
1
answer
1k
views
Windows on a SSD recognized on one computer but not on another
A friend of mine asked me to install Windows on his new SSD. I use a dual boot system, with Ubuntu and Windows 10. I made a bootable flash USB of W10 so I could install it on his SSD, connected to my ...
0
votes
3
answers
126
views
Sd card was partitioned. Need it as 1
I have 64gb sd card. I put an ubuntu os on it. It failed to install. Went to format and overwrite to find it was partitioned. I tried diskmgmt. Tried right clicking on individual drives to delete them....
1
vote
2
answers
175
views
Formatting new identical HDDs, one taking way longer
I have recently purchased 2 identical HDDs:
Model Family: Seagate BarraCuda 3.5
Device Model: ST4000DM004-2U9104 (labeled as ST4000DMZ04)
Capacity: 4.00 TB [3.64 TiB, 4000787030016 bytes]
I've ...
0
votes
2
answers
438
views
why my hard drive is readonly? and how to fix it
I formatted my laptop
and now i am getting that my hard drive (D:) is read-only and I cannot partition it or copy any files on it.
I tried to add "Everyone" and gave that user full access ...
-2
votes
1
answer
45
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
0
votes
2
answers
174
views
External Hard Drive Won't Format - Set to GPT/RAW
I'm trying to format an external hard drive, preferably to exFAT, but nothing is working.
If I check the details of the disk in diskpart, I get this:
And, this is what it looks like in disk ...
0
votes
0
answers
268
views
How to change all numbered paragraphs using one numbering format to another
Somehow, I have a Microsoft Word document with a lot of numbered paragraphs that aren't showing the intended number.
This seems to be because the document has a numbering format that's not actually ...