| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Treating numbers as string variables to preserve zeros at the beggining
Hi, I am just basically sorting through a huge dataset and grabbing unique
codes and storing them in an array for later use. Some of the codes are numeric and some are alphanumeric therefore I am storing them as strings. However, when a code is for example 000578 - once a recall this from the array it has become 578. Is there anyway to preserve the entire code, i.e. make the array recall 000578. Thanks for any suggestions. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Treating numbers as string variables to preserve zeros at the beggining
Format the cells that receive the recalled values as text.
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Graham Whitehead" wrote in message Hi, I am just basically sorting through a huge dataset and grabbing unique codes and storing them in an array for later use. Some of the codes are numeric and some are alphanumeric therefore I am storing them as strings. However, when a code is for example 000578 - once a recall this from the array it has become 578. Is there anyway to preserve the entire code, i.e. make the array recall 000578. Thanks for any suggestions. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table treating numbers as text in value field | Excel Worksheet Functions | |||
| userform combobox treating numbers as text | Excel Programming | |||
| Sort does not preserve string of additions | Excel Worksheet Functions | |||
| How do I write code to preserve variables values for future use. | Excel Programming | |||
| How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
Linear Mode
