>> but doesn't mean that's what will be written there. Not in Excel-land. This presents some challenges when you're trying to actually restrict what might go there.
>>You could try entering a date and format it as "#,##0.00". Yeah. And I could format the values according to whats in there, which would remove the scientific notation aspect, but which would also put commas in exported numbers. Excel's a hell of a thing.
