How do I convert dates mm/dd/yy to general and still look the
Has to do with exporting Excel data into another program to create bar codes.
We have an internal problem that changed dates imported into Excel from a
host system to m/d/yyyy (date format) from mm/dd/yy (general format). My IT
group is figure out why and how my imported data was changed. In the
meantime, I can't get it back to general without retyping. I can reformat the
date or change the regional setting to view dates as mm/dd/yy (date), but
that doesn't t help the person on the other end.
"Rick Rothstein" wrote:
Others have told you why you cannot do what you asked, but I am curious...
why do you think you needed to do what you asked for in the first place?
--
Rick (MVP - Excel)
"jean" wrote in message
...
|