Exporting to US csv (1 Viewer)

jaryszek

Registered User.
Local time
Today, 13:11
Joined
Aug 25, 2016
Messages
756
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
 

Attachments

  • Screenshot_8.jpg
    Screenshot_8.jpg
    85.7 KB · Views: 101
  • Database14.accdb
    532 KB · Views: 36

June7

AWF VIP
Local time
Today, 12:11
Joined
Mar 9, 2014
Messages
5,423
I check "Export data with formatting and layout". Number does not have decimals.
 

jaryszek

Registered User.
Local time
Today, 13:11
Joined
Aug 25, 2016
Messages
756
thank you June7.

Hmm i have to check this one more time,
Jacek
 

Cronk

Registered User.
Local time
Tomorrow, 07:11
Joined
Jul 4, 2013
Messages
2,770
One way of getting the formatting you want is to create a query that formats your data and then export the query
eg
Code:
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.
 

Users who are viewing this thread

Top Bottom