Number format in excel exporting

[lmenendez_grupo_pinero]

Hi,

I have a regular pivot table where I can see for exemple a number like '0.42' or '0,42'.

When I export to excel the numbre becomes in '.41916'.

So I have to formatting it in excel every time.

Is it possible to receive in excel a '0,42' or '0.42'?.

Thanks

[abhijitnalekar]

Hi @lmenendez_grupo_pinero ,

Format the field or column either with num() function or predefine option from the properties of the specific field.

[lmenendez_grupo_pinero]

Hi, I already did so, but it seems does not work (If I've understood your message)

[abhijitnalekar]

Is it possible to share QVF with sample data on which you are working?

[lmenendez_grupo_pinero]

Sure.

[abhijitnalekar]

Hi @lmenendez_grupo_pinero ,

Please find attached below the screen of exported excel. Are you looking same thing?

[lmenendez_grupo_pinero]

Yes I look for the same result in excel directly (whithout doing any formatting work in excel).

[abhijitnalekar]

Hi @lmenendez_grupo_pinero ,

I have done nothing to your QVW. It must be a system-level number formatting issue.

Can you please check what number formatting is saved in your system by following the below steps.

1. Open Control Panel.

2. Locate and select Change date, time, or number formats within the Clock, Language, and Region category.

3. The Region dialog box will appear. Click Additional settings.

4. Check the Numbers Tab. In your case check highlighted property.

Hope this solves the purpose

[lmenendez_grupo_pinero · Accepted solution]

So it is not a qview question.

I thought I would be able to solve it with a qview parameter.

In this case I will have to report to my PC adminsitrator.

Thank you very much!

[abhijitnalekar · Accepted solution]

You are Welcome.

If you think this helps you get the solution please accept it as a solution.