Date Problem

[Agamemnon]

HI,

I have the following date problem and I can't figure out how to solve it.

On sheet "Parameters" in Cell "A1" I have the date value 01/01/2006
I use this value in vba to make a unique string with VBA Code:

Range("PARAMETERS!A2") = "9999"& Range("PARAMETERS!A1") &"OLP"

On my computer this gives as a result:
999901/01/2006OLP

When I sent the file to my collegue he gets the following result:
99991/01/2006OLP
He misses the first 0 of the date.

Has somebody an idea which setting I have to modify so that my collegue also can have the first result?

Working with dates is probably the most difficult thing to do in Excel !!

Thx,
Aga

 

[Andrew Poulsom]

Maybe try:

Range("PARAMETERS!A2") = "9999"& Range("PARAMETERS!A1").Text &"OLP"

 

[Agamemnon]

Thx,

This worked out great.

Aga