Sat 24 Jun 2017

Excel Quiz 53

By |Saturday, June 24th, 2017|Categories: Quizzes|Tags: , , , , , , , , , , , , , , , , , , |0 Comments

Excel Quiz 53 - A Quiz on Data Tab in Excel

This quiz checks your knowledge about Data tab in Excel.

Sat 11 Oct 2014

Article 6 - Convert Text Format into Number Format

By |Saturday, October 11th, 2014|Categories: Articles|Tags: , , , , , , |0 Comments

This article was long pending after I wrote Covert Number Format into Text Format.

This post essentially deals with the fact that if a cell has number in text format, how to convert that value into Number format so that it becomes usable for calculations and for other purposes. (Exclusion - If a number has been entered as accounting format 12- i.e. not with leading minus sign, this article doesn't cover this)

Once again, we will look into this problem statement from 4 angles -

1. Formula Way
2. Manual Way
3. Hybrid Way (Both Manual and formula ways combined together)
4. VBA Way

But first, after conversion, how will you know the cell value is converted into number or not. You can use any one method from below -

(more…)