Group:  Microsoft Excel ยป microsoft.public.excel.setup
Thread: date formatting error

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

date formatting error
TMF in MN 29.09.2006 15:49:01
My spreadsheet has several columns with dates entered. Just today the data
is reading 38986 instead of 09/26/2006. I checked the formatting and it is
set up right. Is there something else I can update so these dates appear
correctly?

THANK YOU
TF
Re: date formatting error
Dave Peterson <petersod[ at ]verizonXSPAM.net> 29.09.2006 16:02:15
Try tools|Options|View and uncheck formulas.

This setting can be toggled via ctrl-` (control-backquote)
it's just to the left of the 1/! on my USA keyboard

TMF in MN wrote:
[Quoted Text]
>
> My spreadsheet has several columns with dates entered. Just today the data
> is reading 38986 instead of 09/26/2006. I checked the formatting and it is
> set up right. Is there something else I can update so these dates appear
> correctly?
>
> THANK YOU
> TF

--

Dave Peterson

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net