Maddening date format issues

[captbluefin]

We have two office computers that run the same .xlsb (not at the same time). Call them Computer A and Computer B

Example of issue:

Cell A6 contains a date. For the sake of discussion it displays 06/18/24 in A6 on the sheet.

If we open the sheet on Computer A, click on cell A6 and look at the formula bar, it displays 06/18/2024. Computer B displays 6/18/2024. Computer B drops the leading 0 when you look at the fomula bar. The cell on the sheet always shows the 0 when using either computer.

We use the date in VBA to create a file name. We need to create a file name in MMDDYY format.

Example:

Please Login or Register  to view this content.

The variable strFile needs to contain: 061824.pdf

The dropped zero causes issues with the code.


Computer B will not create the file - it drops the 0 from the month.

Both computers use the same workbook at different times during the day.

Why is Computer B dropping the leading 0 from 06/18/24 when you look at while computer A does not.
As always, any help is greatly appreciated.

Thanks

[Pete_UK]

This could be a Windows setting rather than specifically to do with Excel. If you click on Control Panel, then Time & Language you can navigate to several panels where you can set the Short Date format - ensure this is the same on both machines.

Hope this helps.

Pete

[TMS]

This doesn't look right to me:

Please Login or Register  to view this content.

I'm not in a position to test it, but shouldn’t it be like this:

Please Login or Register  to view this content.

[captbluefin]

Pete_UK is spot on!!!!!!!!!!

After dinner tonight I fired up excel on my home computer.
Formatted A1 as date MMDDYY
Entered 06/18/24 into A1.
Sure enough the formula bar displayed 6/18/2024

As per Pete's suggestin, navigated to the date and time format settings for Windows. Swithched the format to MMDDYY.

Instantly the formula bar changed to 06/18/2024. No idea why the format for the year is still 4 digits. As long as we can take the left, middle and right of the cell to make the file name, we're psyched.

Thanks to all that have taken the time to look and respond!!!!!!!!!!!!!!!!!!!!!!

[Pete_UK]

Glad to help - thanks for the rep.

I just noticed your Join Date of 2003. You must have been one of the earliest members to join the forum.

Pete

[TMS]

@Pete: 1,473 out of 1,355,638 members. He appears on page 50 of the members' list.

[romperstomper]

Couldn't you just use:

Please Login or Register  to view this content.

rather than messing about with regional settings?