Number format for .xlsx file

[Z1Wu]

There is a setting of number format (Csv-preview: Number Format) in the congiruation of this extension. I change the setting to 'g5' to show 5 significant number. But it seems that this setting only works for .csv format. When I open a .xlsx file, the numerical number still shows 2 significant number. xlsx file in vscode excelviwer extension: same xlsx file in Windows Excel :

How can I change the number format for xlsx file? Thank you in advance.

[xwjBupt]

Hi @Z1Wu how did you change the way to show 5 significant number? i do also change the csv-preview number format to g5, but it still only shows 2 number? thank you so much!!

[BeinerF]

also does not work for *.csv on my side

[Gerrie-Cui]

@Z1Wu @BeinerF @xwjBupt Have you solved this problem now?