Numbers stored as text
Is there an efficient vba module to convdert any numbers stored as text in a
file. This is a problem with many accounting systems that extract data to a "Excel File". Using vllokups ad such creates problems when one file is in stored as text and the other is stored as a number. Thanks |
Numbers stored as text
without knowing the layout, it's pretty hard to come up with some code.
what i have done is copy a blank cell, pastespecial over the number stored as text and select add and then ok. but if there is some consistent layout, just post back. -- Gary Excel 2003 "lwm" wrote in message ... Is there an efficient vba module to convdert any numbers stored as text in a file. This is a problem with many accounting systems that extract data to a "Excel File". Using vllokups ad such creates problems when one file is in stored as text and the other is stored as a number. Thanks |
Numbers stored as text
Unfortunately no layout. Thye are nornally mixed with text entryies. An
example are part numbers. I some are numeric and some are alphabetical Excel stores as Text. Unfortunately Excel looks at some as text and sosme as numbers. This is not a new problem with excel. It has been a problem for many ages. "Gary Keramidas" wrote: without knowing the layout, it's pretty hard to come up with some code. what i have done is copy a blank cell, pastespecial over the number stored as text and select add and then ok. but if there is some consistent layout, just post back. -- Gary Excel 2003 "lwm" wrote in message ... Is there an efficient vba module to convdert any numbers stored as text in a file. This is a problem with many accounting systems that extract data to a "Excel File". Using vllokups ad such creates problems when one file is in stored as text and the other is stored as a number. Thanks |
All times are GMT +1. The time now is 09:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com