Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A need for a macro that is beyond my ability....This macro is to be used in a
csv file. In Column "C" I have Part numbers that are formated as 00000000 or 50004590...these do not cause me any issues...and should be left alone. But in Column "C" I can also have part numbers that are formated as 000.0000 or 440.4300. Excel insists on removing any trailing 0's when opening and saving a CSV file...whenever it sees a decimal point in Part Number. I'd like a macro that scans column "C" and when it finds a Part number that equals a 000.0000 format it will convert it to text and add any missing trailing 0's (up to four). My plan is to save as CSV but not re-open in Excel or save, which (of course) would again strip training 0's. Thanks in advance....Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and replace macro | Excel Discussion (Misc queries) | |||
Find & Replace and Find & Insert macro help needed | Excel Programming | |||
Using Find and Replace to replace " in a macro | Excel Programming | |||
Help with find and replace macro | Excel Programming | |||
Using Find & Replace in macro | Excel Programming |