A
aukselp
We have a worksheet (Excel 2000) that was e-mailed to us.
When we open it, it says there are macros, which there
aren't. No matter if we say "Disable" or "Enable" macros,
all cells are formatted to "General", and when sorting,
the numbers 10000, 7102, 1169 sort as: 10000, 1169, 7102.
We can try to format as number, but to no avail. Sorting
still isn't right. Have seen this many times before, but
don't know how to resolve. Can you help? Thanks.
When we open it, it says there are macros, which there
aren't. No matter if we say "Disable" or "Enable" macros,
all cells are formatted to "General", and when sorting,
the numbers 10000, 7102, 1169 sort as: 10000, 1169, 7102.
We can try to format as number, but to no avail. Sorting
still isn't right. Have seen this many times before, but
don't know how to resolve. Can you help? Thanks.