i have an excel spreadsheet that i've been using for years. the first column has always been a series of dates. recently tho when i opened file the dates column is now unformatted i.e. just numbers. when i reformat to dates and save all looks fine until i reopen the file and its back to the way it was, i.e. numbers again. please help. thx
Have you added any VBA code to the workbook or installed an excel addin recently?
Maybe you can attach the workbook
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
added pamfax from skype - i think problem occurred since then - can i undo things
Not sure what pamfax is,try uninstalling it
still not quite there - any other advice - pls
Do you mean that have tried uninstalling pamfax? If that didn't work attach the workbookOriginally Posted by evr
one possibility have a look in custom formats and delete any that start [$-409]
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks