| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert data type
I have a document that was forwarded to me in the United States from our
sister company in Italy and the qtys are being referenced as shipping, '4,0000 (formatted as text) in the cells where I requested 4ea be shipped. I know that they are really meaning that they shipped 4ea but I have an entire spread sheet of about 5000 items that I would like to compare against my actual request to be sure the entire order was completed. I have tried to "format column" to "number", but it multiplies and populates the field as 40,000. Does anyone have any idea how I can manipulate this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Convert data type
=--SUBSTITUTE(A1,",",".")
-- Gary''s Student - gsnu201001 "CandiC" wrote: I have a document that was forwarded to me in the United States from our sister company in Italy and the qtys are being referenced as shipping, '4,0000 (formatted as text) in the cells where I requested 4ea be shipped. I know that they are really meaning that they shipped 4ea but I have an entire spread sheet of about 5000 items that I would like to compare against my actual request to be sure the entire order was completed. I have tried to "format column" to "number", but it multiplies and populates the field as 40,000. Does anyone have any idea how I can manipulate this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to convert date type to text type | Excel Discussion (Misc queries) | |||
| Convert raw planning data into a 'calendar type' view | Excel Discussion (Misc queries) | |||
| Data type auto convert | Excel Discussion (Misc queries) | |||
| 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) | |||
Hybrid Mode
