Hints and tips home » Excel hints and tips » Convert Text into Number
Convert Text into Number
Some times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions
To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint
eg TEXT(Ref) or TEXT(formula)
Added by Tom on 23rd November 2006
More Excel hints and tips, like:
- Apply currency format quickly in Excel
- Repeating headings on spreadsheets that print on more than one page
- Repeat action
|
Communication Skills And The Use Of Humour When speaking in public there is nothing to endear you to your audience like making them smile. Humour can be a very useful tool in winning over your audience but it should be used with care. » Article: Effective communication skills |
» Forum post: Manual calculations on a spreadsheet |



Course updates

