How to convert a single digit number in B1 into a two digit text value in C1? I set C1 format as text and tried the TEXT function and get only errors.
The results of the conversion from a single digit number MUST result in a text that appears as 2 numbers. i.e. 1 in B1 when converted must end up as text 01 in C1.
[Solved] Converting single number to text?
[Solved] Converting single number to text?
Last edited by CaliRay on Sat Jan 13, 2018 8:16 pm, edited 1 time in total.
OOo 4.1.3 on Windows 10 Home
Re: Converting single number to text?
Try
Code: Select all
=TEXT(B1;"0#")
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Converting single number to text?
Thanks for the solution. It works perfectly.
OOo 4.1.3 on Windows 10 Home
Re: Converting single number to text?
If you have formatted the cell as text, then Calc will not recognize the formula when you enter it—it will take it as literal text, and that's all you'll see displayed.
Change the cell format back to "Number/General" or some other numeric-capable format and re-enter the formula.
Change the cell format back to "Number/General" or some other numeric-capable format and re-enter the formula.
AOO4/LO5 • Linux • Fedora 23