Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Is any method to reserve leading zeroes in excel template
Is any method to reserve leading zeroes in excel template. Here length for that field is different.
Kindly help on this. I changed the field format to number to restrict scientific format.
If anyone knows.Kindly help
Answers
-
Hi ,
If anyone knows, Please help me on this issue. The issue is related to excel template in bi publisher report.
0 -
In general: Excel is Excel and 0000000123 is just 123 to it because 123 is a number.
0000000123 may seem to your human eye like a text string but it's not. Numbers do not have "leading zeros. Only strings have.
'0000000123' is a string and Excel will always try to see it as a number unless you clearly and explicitly force Excel to treat a column or a cell to behave as a text string.
0 -
Hi Christian,
How we can do this? Can we append single quotes in edit field?
Regards
0 -
It remains a relevant topic.
0
