157
When I export a view containing our sales estimates, from the goals entity to excel all of the cell's appear as "text", including the cell containing only numbers. This means that we can't perform calculations on them.
I have tried to reformat the cells in Excel to numbers, but nothing happens. It's still text and I can't really do anyting useful with it.
Any suggestions? Thanks.
*This post is locked for comments
Hi,
In your excel, select your columns with text and click ctrl + 1 and set the type to number.
Press ok.
Next, press Text to Columns in the data tab.
Click finish.
That should be it.
Regards
Wouter
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (