Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
That's correct. The data types are really for loading the data into Power Pivot where data types are used in the modelling. When you load the data into Excel you are free to apply cell formatting just as we normally would. The data types aren't really relevant to Excel, other than the Date type, which will automatically pick up a date format.
So, if you're only loading the data into Excel, don't worry about setting data types like currency, as this is irrelevant in Excel. Just make sure text is text, dates are dates and numbers are either whole or decimal.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Pam Baillie, Karmel Brockman, Scott Smith, Nadia Dubash, Angela Korn, Jan Elenbaas
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6881
Posts: 30160
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —