Numerical values in a text format

Hi,

I am having a problem with a tool I have made for occ sick.

To summarise you key in the emp number dates reasons, actions etc and it initially has a change script that displays the proposed output details in both the database codes and the descriptions the user would see.

E.g.

Cancer = 0100

In the display area it brings this through with the header 0 but knocks off the end 0

E.g.

010

The other field I have like this is action type

E.g. Sick note recieved = 001

This is just pulling through as 1, even the code is exactly the same and all the formating is the same.

This is then copied to the output tab where it is stored till all the entries are keyed, the next step is to turn the output file in to CSV.

When you run the create csv macro and view the csv file produced you can see it has removed the header 0 as well!

So in short, the spreadsheet macro is knocking off end 0 and the csv macro is knocking off the header 0.

This is my code for the change event which is what copies and looks up the values for the display area:

Please Login or Register  to view this content.

This is the code I have slightly altered for my workbook, which Jerry BeauCaire wrote that creates my CSV file:

Please Login or Register  to view this content.

How are you testing the CSV file? Opening it in Excel again or in Notepad? The former will likely try and convert anything that looks like a number into a number.