Exporting to US csv

[jaryszek]

Hi,

i am exporting table timezones to csv using this settings (US settings):

Problem is that when i am exporting Windows description i have instead of number "90", number "90.00". How can i change this to have always number without decimals after?
It is possible?

Please help,
Best,
Jacek

 

[June7]

I check "Export data with formatting and layout". Number does not have decimals.

 

[jaryszek]

thank you June7.

Hmm i have to check this one more time,
Jacek

 

[Cronk]

One way of getting the formatting you want is to create a query that formats your data and then export the query
eg

select format(TimeZone, "0.00") as [time zone], .....

There are some issues with this. You won't have the same header name and you'll have to watch out for null entries.