LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
E. E. is offline
external usenet poster
 
Posts: 1
Default Wrong number format after exporting from sharepoint list

Hello everyone,

At the moment I am facing a problem that might be solved easily, but I
don't get any more ideas. Perhaps someone here had already faced it.
One of our users is trying to export a sharepoint list to Excel (MS
Office Professional Edition 2003). Whilst looking at the list in
sharepoint, there is no issue with the currencies and numbers. After
exporting it to Excel, numbers and currencies are being messed up.
Have a look here http://img67.imageshack.us/img67/6910/problemedwk8.jpg
Several times the number null is added to the original amount, e.g.
instead of have a net price of 412,00 it displays
412.000.000.000.000,00; instead of have 1 room night it shows it as
100.000.000.000.000 room nights and so forth.
This happens only at this specific client desktop. On others it is
pretty fine and exporting the same list is no problem at all.
Everything is displayed correctly. So I am pretty sure it is an issue
with that client desktop and it's (Excel) settings.

I did the following in order to resolve:
+ I opened the regional and language settings and checked for the
number and currency specifications - everything ok there
+ I repaired office with its assistant from the setup CD
+ I installed any additional feature which might be necessary to
interact with sharepoint and so forth
+ I reinstalled entire MS Office and deleted the remaining Excel
configuration files before from the user's folder (C:\Documents and
Settings\%user%\Application Data\Microsoft\Office)

Nothing worked out. Since I have also other duties in the company I
lack a bit of time for researching for hours. Any help or suggestions
are welcome since this getting a small pain ;).

The system used runs:
- Windows XP Pro SP3
- MS Office Professional edition 2003 SP3
- Internet Explorer 7.0.5730.11
- interacts with WSS 2.0 11.0.8173.0

Thanks in advance.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sharepoint List to Excel with Totals Dave_Tho1968 Excel Discussion (Misc queries) 0 October 22nd 07 09:22 PM
Can't Synchronize Excel List with Sharepoint TommyVee Excel Discussion (Misc queries) 0 July 27th 07 10:08 PM
Excel mailing list in wrong format for mail merge Loren Smith[_2_] Excel Discussion (Misc queries) 0 March 8th 07 09:38 PM
Exporting from Excel to CSV results in wrong characters Mark B Excel Discussion (Misc queries) 0 September 13th 06 08:39 PM
sync list with SharePoint is greyed out Mike Bubyn Excel Discussion (Misc queries) 0 November 30th 05 05:09 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"