Convert numbers stored as text to numbers

Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac More...

1. Select a column

Selected column
Select a column with this problem. If you don't want to convert the whole column, you can select one or more cells instead. Just be sure the cells you select are in the same column, otherwise this process won't work.

2. Set the format

Currency format selected
Press CTRL + 1 (or Image of the MAC Command button icon + 1 on the Mac). Then select any number format or currency format.

3. Click Data > Text to Columns

Data tab, Text to Columns button
On the Data tab, click Text to Columns.

4. Click Finish

Finish button
Click Finish right away and Excel will convert the cells.

https://support.office.com/en-us/article/Convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885

Comments

Post a Comment

Popular posts from this blog

Unlock PUK for Celcom

Guys Hahaha.. i got this from one website that explain how to get puk number without calling service center. Only for Celcom Users. Please see as below Langkah-langkah yang perlu diikuti : remove and see at the back of the sim card oftenly, there are 3 lines of number as such: 123456 234567 345678 the required PUK is only 8 number and user need to key in 8 number backward refering to the example, the 8 digit that is required is 87654376 dont forget to key in the new pin number after unlock
Read more

Gigabyte ATX Motherboard GA-AB350-Gaming 3 For AMD AM4

Image
   Motherboard  Socket AM4  GA-AB350-Gaming 3 GA-AB350-Gaming 3 (rev. 1.0) Key Features  Specification  Support  News & Awards  Learn more  Buy   Compare GA-AB350-GAMING 3(1.0) GA-AB350-GAMING 3(1.0) GA-AB350-GAMING 3(1.0) GA-AB350-GAMING 3(1.0) GA-AB350-GAMING 3(1.0) GA-AB350-GAMING 3(1.0)     Supports AMD Ryzen™ & 7th Generation A-series / Athlon™ Processors Dual Channel Non-ECC Unbuffered DDR4, 4 DIMMs Fast 2 USB 3.1 Gen 2 with USB Type-A 2-Way CrossFire™ Multi-Graphics Support with Ultra Durable™ Metal Shielding over PCIe Slots Ultra-Fast PCIe Gen3 x4 M.2 with PCIe NVMe & SATA mode support ALC1220 120dB SNR HD Audio with Smart Headphone Amp Realtek® Gigabit LAN with cFosSpeed Internet Accelerator Software USB DAC-UP 2 & 2 Front USB 3.0 Ports with Adjustable Voltage RGB FUSION with Multi-Zone LED Light Show design Swappable Overlay for Accent LED Smart Fan 5 features 6 Temperature ...
Read more

Dell Precision™ T3400* Workstation

Image
System Processors Intel® Core™ 2 Extreme with 1333MHz FSB, 2x4MB L2 cache Intel Core 2 Extreme with 1066MHz FSB, 2x 4MB L2 cache Intel Core 2 Quad with 1066MHz FSB, 2x 4MB L2 cache Intel Core 2 Duo with 1333MHz FSB, 4MB L2 cache Intel Core 2 Duo with 800MHz FSB, 2MB L2 cache All processors support 64-bit computing with Intel EM64T Operating Systems Dell recommends Genuine Windows Vista™ Business Genuine Windows Vista™ Business; Genuine Windows Vista™ Ultimate; Genuine Windows® XP Professional and Windows® XP Professional x6 Edition; Red Hat® Enterprise Linux® WS v.5 Chipset Intel X38 Express chipset Memory Four DIMM slots support up to 8GB1  dual-channel2 DDR2 800MHz or 667MHz non-ECC and ECC memory11 Flash BIOS 8MB flash memory for system BIOS; SMBIOS 2.3.1 support Graphics Support for two PCI Express x16 graphics cards up to 300 watts and with up to 768MB graphics memory including: NVIDIA Quadro® FX 4600; NVIDIA Quadro FX 1700; NVIDIA Quadro® FX 570; NVI...
Read more