Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-03-04 08:09 AM

Store to excel Number format

Hi,

I am storing information generated  into a csv txt file.

However I seem to be having problems with its formatting.

This is how the mobile numbers are exporting:

  • 4.4111E+10
  • start with 44 so will need a '+' adding to it
  • Have +44(0) at the begining
  • Removes the 0 when being stored

Is there any way in Qlikview that i can format this field so that it all stores in the correct format?

Thanks in advance

Natalie

411 Views
0 Likes
0 Replies