Reg, thanks for your response. According to our Tech group all the PCs have
the latest of everything. I ended up just putting in some code to get the
format I wanted before the file was exported. Still not sure what the
difference was, but at least it works on both now.

"Reg" wrote:

I think you may be being haunted by the ghost of y2k, has the 2000 user got
all the latest patches?

Reg


"cottage6" wrote:

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!