Leading zero in tables
Con rispostaHello,
Is there a way to show the leading zero in a table? I'm trying to display "0408" but it keeps returning "408" even when I use excel files tricks it doesn't work. Thanks.
-
Hello and welcome to the Community, Sean!
Hmm... in testing, the only way I've been able to achieve this so far is to have the cell formatted as Text, which will then show the zero. I'm not confident, though, on if that has an impact on any XBRL tagging applied, if that was the case.
Let me know what questions you have on any of the above, or if you need anything else. Thanks for your contributions and chat with you soon!
0
Thanks for posting this, Sean. I don't have any solutions for you, but wanted to join in solidarity on this being an issue. Here are two additional scenarios where this has been a concern for us - 1) in the Northeast, most zip codes begin with a 0, and it's been a longstanding issue to develop workarounds in Excel so they don't fall off. This hasn't been an issue so far in Wdesk since we aren't using zip code data (yet!), but it could become a future concern. 2) We recently revamped our chart of accounts, and our consultant wanted us to use zeroes to start our main fund account numbering. Thankfully, I was able to test it in Wdesk before we finalized the renumbering, saw that the zeroes dropped, and we spent several weeks redesigning the numbering scheme before implementing. We probably could have implemented workarounds, but it's nice to have the data intact. (Hope the extra context is helpful, Mike.)
0
Thank you both for your input! Using Mike's suggestion is the way to go....switching to "Text" maintains the leading zero.
0
Thanks! Just curious - is this a small issue that's only impacting a few cells, or are you working with a larger data set? It's been 18+ months since I encountered this, and seem to recall that the Text change worked initially, but defaulted back to a non-Text format when I updated my data (1,000-2,000 rows) by copying and pasting from an external source. It may no longer be an issue given all of the recent Wdesk updates.
0
Just one cell for me and this is our first year with Workiva, so it's all new to us.
0
Great insights Jennifer K Hewitt. Indeed, quite helpful :)
0
I'm having a similar issue. The source spreadsheet is formatted as text and shows the leading zeroes. The destination spreadsheet is formatted as text but the VLOOKUP is returning the value without the leading zeroes. Why, why, why does this happen? Once I've "told" the spreadsheet what I want, why does it override?
0
I'm struggling to get those pesky leading zeros to populate via a VLOOKUP as well Connie Christianson. How many do you have? Is it always the same number of leading zeros? I tried combining TEXT(VLOOKUP) but still doesn't bring in the zeros. If it is the same number of zeros each time, you could use a prefix and add two zeros, though you'd think there must be a way to pull those in. I'll keep digging
0
If only it could be that simple :) Leading zeroes can vary from 0-2 on a 3-number field. I'm working with large files - the current version has about 12,000 lines
0
Is there already a solution for this problem, instead of formatting it as text?
0
I've just connected with our spreadsheet experts! It looks like setting the value to number or currency and inserting the leading 0 as a prefix should work. Feel free to give this a shot and let us know how it goes!
0Accedi per aggiungere un commento.
Commenti
11 commenti