▲ 18 ▼ How do you get the first "0" in "050" to show in a cell? (programming.dev) submitted 3 weeks ago* by Flagstaff@programming.dev to c/libreoffice@discuss.tchncs.de 9 comments fedilink hide all child comments Even "Number Format: General" still omits the starting 0. I can't even get it to show up if I lead with a space or a "-." What is the trick? This is super-annoying.
[–] n4sdaq@lemmy.dbzer0.com 3 points 3 weeks ago* (1 child) Did you try putting a ' at the start of the cell? permalink fedilink source hideshow 2 child comments replies: [–] Flagstaff@programming.dev [S] 2 points 3 weeks ago Thanks, I do know about that but I want to avoid using an escape char because I want to be able to copy the cell without hidden characters entering the clipboard. permalink fedilink source parent
[–] Flagstaff@programming.dev [S] 2 points 3 weeks ago Thanks, I do know about that but I want to avoid using an escape char because I want to be able to copy the cell without hidden characters entering the clipboard. permalink fedilink source parent