>I have a client who is scanning into Excel a date contained in a barcode. The result is the formula for the field being set to NOW(), so the date is changing, it's not static.
>
>Anyone know what to do about this?
It depends on how, as you said, a client is "scanning into Excel a date contained in a barcode", and how "result is the formula" appears. If he creates a new workbook, then probably he needs to send values, not formulas, to Excel. If he pupulates the existing sheet already containing now() as formula, then this cell should be fixed: it shoukld not contain the formula, etc.
Good Luck
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only