Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Convert Text To Number
Hi, I am dumping data from an external system into Excel via a 3rd party
application. When a particular field comes into JDE, its come in as text. i.e. 00350, 00390. I need these to show as numbers because they are needed in a numerical formula. I can highlight the full range and click on the little warning icon that pops up (when the top left of the cell is a tiny green triangle) and use convert to number. However, I have four different dumps all with the same issue. Its a pain in the butt to have to do this. Is there a formula I can use? Thanks Rob -- Rob Gaffney |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Convert Text To Number
If your data is in A column put B2 = --(a2) or B2 = value(a2).
Copy it down. best wishes Sreedhar "Gaffnr" wrote: Hi, I am dumping data from an external system into Excel via a 3rd party application. When a particular field comes into JDE, its come in as text. i.e. 00350, 00390. I need these to show as numbers because they are needed in a numerical formula. I can highlight the full range and click on the little warning icon that pops up (when the top left of the cell is a tiny green triangle) and use convert to number. However, I have four different dumps all with the same issue. Its a pain in the butt to have to do this. Is there a formula I can use? Thanks Rob -- Rob Gaffney |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Convert Text To Number
Select all and Format to General.
Copy an empty cell and Copy. Select the range to change and EditPaste SpecialAddOKEsc. Note: you will lose the leading zeros because the data is now numeric. If you want them shown use a Custom Format of 00000 Gord Dibben MS Excel MVP On Fri, 25 Apr 2008 01:25:01 -0700, Gaffnr wrote: Hi, I am dumping data from an external system into Excel via a 3rd party application. When a particular field comes into JDE, its come in as text. i.e. 00350, 00390. I need these to show as numbers because they are needed in a numerical formula. I can highlight the full range and click on the little warning icon that pops up (when the top left of the cell is a tiny green triangle) and use convert to number. However, I have four different dumps all with the same issue. Its a pain in the butt to have to do this. Is there a formula I can use? Thanks Rob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert text to number for a range of data in a column | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |