topic Re: Number format in excel exporting in Search the Community

Number format in excel exporting

lmenendez_grupo_pinero — Fri, 08 Oct 2021 09:30:16 GMT

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 — Fri, 08 Oct 2021 09:35:34 GMT

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

lmenendez_grupo_pinero — Fri, 08 Oct 2021 09:42:36 GMT

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

abhijitnalekar — Fri, 08 Oct 2021 09:55:22 GMT

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

lmenendez_grupo_pinero — Fri, 08 Oct 2021 10:05:46 GMT

Sure.

abhijitnalekar — Fri, 08 Oct 2021 11:25:44 GMT

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

lmenendez_grupo_pinero — Fri, 08 Oct 2021 11:33:26 GMT

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

abhijitnalekar — Fri, 08 Oct 2021 11:52:58 GMT

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 — Fri, 08 Oct 2021 11:59:26 GMT

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 — Fri, 08 Oct 2021 12:03:23 GMT

You are Welcome.

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