Hi. It's Excel 2007 on terminal server issue. If I type some numbers like: 1.22 or 12.31 or 10.27 etc and leave a cell then it changes to date, for example 22 Jan; 31 Dec, 27 Oct etc. I've check cells format and no matter what is set, it always changes to dates. The issue is present in whole Excel: old/new files, every sheet ad so on. The profile reset was performed but didn't help. Any idea how to troubleshoot this?
Thanks
Change the numberformat of the cells to Number, instead of General.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks for your reply. But as I said. No matter what cell's value is set, it still changes. And all cells in all sheets/excel files (old one or already created one) are affected.
Not the value, the numberformat.
Oh, and check what your system locale settings expects as a decimal separator.
Last edited by Olly; 10-10-2014 at 01:04 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks