Tag Info

Hot answers tagged

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:


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

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

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.


1

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



Only top voted, non community-wiki answers of a minimum length are eligible