emailing spreadsheet loses date format

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

When I e-mail a spreadsheet with dates, the receipint just
sees a long # instead and has to reformat. Since I have
to send this spreadsheet weekly, this is frustrating. Any
suggestions???

Thanks!
 
sam said:
When I e-mail a spreadsheet with dates, the receipint just
sees a long # instead and has to reformat. Since I have
to send this spreadsheet weekly, this is frustrating. Any
suggestions???

Thanks!
Click to expand...

Try widening the column a little. It could just be that the screen/printer
driver on the recipient's machine can't fit the characters into the width
that's OK on yours.
 
I'm gonna guess that you use a short date format (like mm/dd/yy) and the
recipient uses something like: mm/dd/yyyy.

Excel picks this up from your windows regional settings (if you use that short
date format). If you change the format of the date (January 13, 2003 or even
mm/dd/yyyy), that might be enough. (If you use mm/dd/yyyy and another user uses
mm/dd/yy, then that column looks a little too wide for them.)

Windows Start button|settings|control panel|regional settings applet
date Tab
Is where'd you change it.

(or maybe just change the header to be wider!)
 
Back
Top