Hi
I have a problem with my goods's code.my goods's code is that bellow
codes and that codes make a problem with Excel when i take report from
my database..
In database ın excel
11E15 1,10E+12
11E16 1,10E+13
11E20 1,10E+20
I want to write that goods's code in Excel like my database format and
i was write that bellow function for that problem.
Function e_repair(car_code)
If Len(car_code) > 10 And Left(car_code, 2) = "11" Then
e_repair = "11E" & Len(car_code) - 2
End If
End Function
BUT THAT FUNCTION DON'T RUNING..HOW CAN I DO IT?
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
