sunilvedula
Sunil
- Local time
- Today, 18:18
- Joined
- Jan 18, 2007
- Messages
- 138
Hi All,
I am importing excel sheet data into a table. It has a field for amt and it imports into temp table as text and then sends it to main table where it converts it into currency. Now the problem is the data from the excel sheet looks like 00002145 and when it comes to the main table it makes it $2,145. I want it to be 214.5. We can for sure assume the last two digits to be after teh decimal.i.e. units.
I am importing excel sheet data into a table. It has a field for amt and it imports into temp table as text and then sends it to main table where it converts it into currency. Now the problem is the data from the excel sheet looks like 00002145 and when it comes to the main table it makes it $2,145. I want it to be 214.5. We can for sure assume the last two digits to be after teh decimal.i.e. units.