Windows 8 and 8.1 Forums


how to prefix a zero in WORKS spreadsheet

  1. #1

    how to prefix a zero in WORKS spreadsheet


    Hi Guys

    I have all my tel numbers in a Works spreadsheet, but notice zeros are missing at start of number, can they be added all at once any way?

      My System SpecsSystem Spec

  2. #2


    Posts : 54
    Windows 7 Pro plus Windows 8.1 Pro VM


    I googled and got this .. does it help ?

    Add/ insert leading zeros to numbers and text with Concatenate function

    If you want to insert specific digit of leading zeros into each number, for example three leading zeros for each number, you should try the Concatenate function.
    Step 1: Enter the formula =Concatenate ("000", A1) in a blank cell and press Enter key. In this case, we enter the formula in Cell C1.
    Step 2: Click the Cell C1, and drag the fill handle across the range that you want to fill. Then you will view numbers in A1:B6 are pated to C16, and each number contains three leading zeros.
      My System SpecsSystem Spec

  3. #3


    did not work for me, message said its not a Works formulas, are the " supposed to be there?
      My System SpecsSystem Spec

  4. #4


    Central IL
    Posts : 3,468
    Linux Mint 17.2


    Download Libre Office from libreoffice.org and use that. Works is no longer supported by Microsoft.
      My System SpecsSystem Spec

  5. #5


    Hi Broe

    thanks for reply, but I dont want OO, I have just UNinstalled it, and I dont want support from MS for Works, its all working great apart from the zero being omitted, there is a way, will find it soon.
      My System SpecsSystem Spec

  6. #6


    Posts : 1,875
    Windows 10 Pro Prieview x64


    1. Select the field where you want to preserve leading zeros.
    2. On the Format menu, click Field.
    3. Under Format, click Number.
    4. In the Appearance box, click 01235.
    5. In the Number of digits box, type the maximum number of leading zeros you want to preserve, and then click OK.


    Works: How to Preserve Leading Zeros in a Number in a Spreadsheet Cell or Database Field
      My System SpecsSystem Spec

  7. #7


    Central IL
    Posts : 3,468
    Linux Mint 17.2


    Quote Originally Posted by frenchman96 View Post
    Hi Broe

    thanks for reply, but I dont want OO, I have just UNinstalled it, and I dont want support from MS for Works, its all working great apart from the zero being omitted, there is a way, will find it soon.
    Libre Office is not Open Office. The problem with works, is that it is limited in what it will do.

    Libre Office is cross-platform capable.
      My System SpecsSystem Spec

  8. #8


    Posts : 1,875
    Windows 10 Pro Prieview x64


    Quote Originally Posted by broe23 View Post
    Libre Office is cross-platform capable.
    As is open office. Excel is better though.
      My System SpecsSystem Spec

how to prefix a zero in WORKS spreadsheet
Related Threads
Hi Brink! Im sure theres a good explanation, when everybody else says, that the new skydrive app is so amazing, but in my case, not so much. When i had Windows 8.0, my only problem with the skydrive was, that if i saved some changes to a document, and didnt change its name, skydrive assumed,...
Spreadsheet in Software and Apps
Basically C5 is pos #, C4 is neg # & C3 is pos # but needs to be neg 19666
Solved Microsoft Works in Software and Apps
Will Microsoft Works run on Windows 8? Thanks.
Lotus 123 Spreadsheet in Software and Apps
What release of Lotus Smart Suite is needed to operate properly on a new Lenovo H430 i5 chip machine? I have tried version 9.8 millennium edition (about 3-5 years old which worked on a vista laptop) but it will not load on this machine. Note the version I tried is not 9.8.1, .2, .3, .4, .5 etc. ...
I have two HP Deskjet 3050 printers; one on main machine with Win7 Ult, and the other on backup machine with Win8 Pro OEM. I am running MS Office 2010 on both machines. I have files with XL Spreadsheets created from MS Office 2003, 2007 and 2010. All versions of all XL spreadsheet files can...
Godmode WORKS in General Support
Right click desktop, chose new folder, then in the area to name the folder paste this there: GodMode.{ED7BA470-8E54-465E-825C-99712043E01C} then press enter, and INSTANT godmode! :D *Quick note* For those that want to go back to your original Windows 7, you can use Godmode to put it...
Solved Refresh -- works! in Installation & Setup
In messing around with installing Win7 apps in Win8DP, I somehow totally hosed up the display so that all I got was a black screen with a mouse cursor. So, I rebooted and chose the Refresh option, which surprisingly, worked! And, as the text claimed, it removed ALL the apps in the process (no...
Eight Forums Android App Eight Forums IOS App Follow us on Facebook