Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format - Text to Number or vice versa
Hi, when you export data from databases... often number fields are formatted
as text. This is a problem, because sometimes formulas won't recognize the data as numbers. So, I have often had to manually convert each field to the number format by hitting F2, Enter and repeat... sometimes for several hundred, sometimes thousands of rows. I've seen several other accountants do the same thing as well. Selecting the column and changing the format just doesn't do it. Even copying and pasting the columns somewhere else... even without the formatting doesn't do it. Anyone else ever run into this problem? Any solution? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format - Text to Number or vice versa
This will coerce it all at one go into real numbers:
Copy a blank cell, the select the entire col of text numbers, right-click paste special check "Add" OK Any good? hit the YES below -- Max Singapore http://savefile.com/projects/236895 Downloads:27,000 Files:200 Subscribers:70 xdemechanik --- "JeffC" wrote: Hi, when you export data from databases... often number fields are formatted as text. This is a problem, because sometimes formulas won't recognize the data as numbers. So, I have often had to manually convert each field to the number format by hitting F2, Enter and repeat... sometimes for several hundred, sometimes thousands of rows. I've seen several other accountants do the same thing as well. Selecting the column and changing the format just doesn't do it. Even copying and pasting the columns somewhere else... even without the formatting doesn't do it. Anyone else ever run into this problem? Any solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hexadecimal to Decimal (and vice versa) | Excel Worksheet Functions | |||
FirstName, LastName and vice versa | Excel Worksheet Functions | |||
From pricelist to productslist and vice versa... | Excel Discussion (Misc queries) | |||
convert a range of lowercase text to upper text or vice versa | Excel Worksheet Functions | |||
how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions |