C
cottage6
Hello,
One of the users here created a spreadsheet that exports to Datacom. It has
dates in it that need to export without the slashes and he's got one date
column that needs to combine with some text; it's a little different but
needs to be done that way. He has listed each Sat. date in 2008 using
formulas that increment by 7. The dates are formatted as Custom mm/dd/yy_).
The current Sat. date is referenced in several sheets and the data is copied
and pasted into another sheet as values, and then copied to a new workbook.
There the Sat. date is formatted (and here's the goofy part) in his macro as
Selection.NumberFormat = " cirmmddyy". So he needs a space combined with cir
and the date with a leading zero without slashes. Anyway one of the users
has Windows 2000 with Excel 2002; the spreadsheet exports perfectly for him.
Another user has Windows XP with Excel 2000; the export looks like a 4-digit
year instead of 2 digits. Both Regional Settings are the same on the PCs. I
have XP and Excel 2003 and the spreadsheet is okay on mine. I've included
part of the first row:
EXBIGM700 18011220 cir022308022308
Any ideas why this would act differently? TIA and have a good day!
One of the users here created a spreadsheet that exports to Datacom. It has
dates in it that need to export without the slashes and he's got one date
column that needs to combine with some text; it's a little different but
needs to be done that way. He has listed each Sat. date in 2008 using
formulas that increment by 7. The dates are formatted as Custom mm/dd/yy_).
The current Sat. date is referenced in several sheets and the data is copied
and pasted into another sheet as values, and then copied to a new workbook.
There the Sat. date is formatted (and here's the goofy part) in his macro as
Selection.NumberFormat = " cirmmddyy". So he needs a space combined with cir
and the date with a leading zero without slashes. Anyway one of the users
has Windows 2000 with Excel 2002; the spreadsheet exports perfectly for him.
Another user has Windows XP with Excel 2000; the export looks like a 4-digit
year instead of 2 digits. Both Regional Settings are the same on the PCs. I
have XP and Excel 2003 and the spreadsheet is okay on mine. I've included
part of the first row:
EXBIGM700 18011220 cir022308022308
Any ideas why this would act differently? TIA and have a good day!