Custom format for assigning decimal to imported text
I have brought over data from a IBM Query 36 application and imported into Excel as txt. The numbers imported without decimals, and are designed to be one decimal, e.g.
79.8 is displayed in Excel as 798. Is there custom formatting I can assign to the
applicable cells to display the numbers as they should appear(79.8 rather than 798). Excel tells me the applicable data has been assigned a "General" format. If I change the format to "Number", the decimal is assigned to the incorrect location, such as 798.0.
The data in these columns will be constantly updated, so it would be more convenient to have a custom format rather than to convert the number with a formula. Thanks for any help!
Keys to the Problem Custom format for assigning decimal to imported text
You could apply the custom number format #0"."0;-#0"."0;0
Select the cells containing the numbers, click the little arrow to the right of NUmber on the home tab > Number > Custom > Type: #0"."0;-#0"."0;0
However, if you ever wanted to do some processing on these numbers it would be confusing that the value in the cell is actually 10 times what it appears, so if you wanted to test if a value was greater than 100 you would have to write it as =IF(A1>1000,...)
I would instead divide all the values by 10 after import.
Quite easy to do:
- enter 10 in a cell
- copy the cell
- select the imported numbers
- paste (the drop arrow at the bottom of the button) > Paste Special > Values , Divide
You could have this done by a macro after the import if desired.
To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.
Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.
Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.
Another Safe way to Repair the Problem: Custom format for assigning decimal to imported text:
How to Fix Custom format for assigning decimal to imported text with SmartPCFixer?
1. You can Download SmartPCFixer here. Install it on your computer. When you open it, it will perform a scan.
2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.
3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed
Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 126.96.36.199059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.188.8.131.52 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.184.108.40.206,How to Fix Error 0x0000c1f5 Solución?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Tech Support: Date Function,Solution to Error: deleting files in file history,[Anwsered] Deleting old keys before installing new antivirus,How Can You Fix - Desktop icons show as generic icons?,Fast Solution to Error: Data execution program and IE & or IE 8