- Joined
- Jan 16, 2008
A guy at work just sent me this:
Wut?!?!?
He sends me a three line email that I don't understand, I ask what the hell he means and he send me this back...
What the hell am I supposed to say back to this?!?!?!
Sorry, for the unclarity. It looks the same, but in Excel lingua it is a different field format. The only negative thing about this is that the format of the document will be even more sensitive than before. And you can't take a time formated field and just turn it into "text" format. Excel will try to recalculate the time into a decimal number... (That's just how Excel works).
So, yes, please test this with one of the existing shotlists. Since the old ones are created with the time format, they will have to be "converted" to text. I found a way to do this: Copy the data from the time column. Paste it into a Word document. Select all in Excel and set the field format to "text". Select the pasted text in the word document. Go to the excel document and paste it into the coulumn usign the "paste special" command. Select "text" format.
Let me know if this is a workable soulution and we'll implement it to Production as well.
Wut?!?!?
He sends me a three line email that I don't understand, I ask what the hell he means and he send me this back...
What the hell am I supposed to say back to this?!?!?!