Number Format in Excel Services.

Question

All,

Where is the format of negative numbers controled from in Excel services?

I have a sheet published, which in the excel client shows negative numbers in parenthesis, in excel services it shows with a minus sign.

Thanks

Stu

Answer 1

 

Hi Stu,

 

The formats of negative numbers are set from Excel client side.

 

I make a simple sample and the formats displayed normally in my local. Here is the result.

 

 

Could you please do some tests and make sure if your issue is reproducible?

If so, could you please upload the document to following workspace so that I can do further investigation.

Workspace URL: (https://sftemea.one.microsoft.com/ChooseTransfer.aspx?key=e2f7de56-178b-4b21-ac46-7fa5a4a0d769)

Workspace Password: nCfF%3wuxr

 

 

Lambert Qin

TechNet Subscriber Support in forum

If you have any feedback on our support, please contact [e-mail]  

---

Sincerely,

Lambert Qin

Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Hi Stu,

 

I have not heard from you for two business days, could you please let me know the status of your issue?

 

If you need further assistance, please do not hesitate to let me know.

 

Lambert Qin

TechNet Subscriber Support in forum

If you have any feedback on our support, please contact [e-mail]  

---

Sincerely,

Lambert Qin

Posting is provided "AS IS" with no warranties, and confers no rights.

Answer 3

Hi Lambert,

I re-published the sheet & all is good.

Thanks for your help.

Stu