Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Spreadsheet

25 Aug 2011   #1
flogit

windows 7 home premium 64bit
 
 
Spreadsheet

Hello.Just installed Open Office,Now trying to use the spreadsheet system.
I thought that I would make an address book up of family names etc,Now when it comes to entering their telephone ie:01683***** when its in the column the nought aint there can anyone explain to me why this is and is there a way to get the 0 to be there.
Running windows 7.& now OO..
Thanks.


My System SpecsSystem Spec
.
25 Aug 2011   #2
Irene

Windows 7 Home Premium 64bit
 
 

I don't have Open Office, but in Office I would format the cell as 'General'.

Sorry I can't be more specific for OO.

Maybe I'll download it - just for reference.
My System SpecsSystem Spec
25 Aug 2011   #3
kado897

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit Service Pack 1
 
 

Quote   Quote: Originally Posted by flogit View Post
Hello.Just installed Open Office,Now trying to use the spreadsheet system.
I thought that I would make an address book up of family names etc,Now when it comes to entering their telephone ie:01683***** when its in the column the nought aint there can anyone explain to me why this is and is there a way to get the 0 to be there.
Running windows 7.& now OO..
Thanks.
If you format the cells as text it should retain the leading zero.
My System SpecsSystem Spec
.

25 Aug 2011   #4
xxxdannyxxx

Windows 7 Home Premium x64 SP1
 
 

Hello flogit

If you right click the column in question,then format cells and click text and then ok that will allow a zero first

-capture.png

Danny

Edit-Keiths got fast fingers tonight


My System SpecsSystem Spec
25 Aug 2011   #5
GEWB

Several flavors of Linux (Mint primary) / 32bit XP, Win7 HomeP / 64bit Win7 Pro, Ultimate / 64Win8.1
 
 

Change the way you enter the phone number by using decimal points.

Select your cells (or column) and right click, then click Format Cells.

Under Options, select "1" for Leading Zeroes.

Now enter your numbers as:

0.xxx.xxxx

Regards,
GEWB
My System SpecsSystem Spec
26 Aug 2011   #6
flogit

windows 7 home premium 64bit
 
 

many thanks all concerned all is well again.
My System SpecsSystem Spec
26 Aug 2011   #7
kado897

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit Service Pack 1
 
 

You are welcome flogit. Thanks for posting back.
My System SpecsSystem Spec
Reply

 Spreadsheet




Thread Tools






Similar help and support threads
Thread Forum
works spreadsheet
Starting a few months ago any spreadsheet I created in Microsoft Works would develop the "hiccups". The spread sheet would create and you could post entries but only between the fluctuations of the "hourglass" icon cycling about every 2 seconds. I would resolve this by restoring to an earlier...
Microsoft Office
A lot of ##### in my spreadsheet.
I have decided to download my bank account monthly balance sheet,Got it into a spreadsheet okay But the last column with the total balance I get a lot of these ########. With no figures. Example 100.00 I get ####### How can I solve this please,The other column's with input's show the figures...
Microsoft Office
A spreadsheet moron looking for help.
What is the formula that will calculate the percentage of random cells?
Microsoft Office
Opening a spreadsheet
I get a monthly listing in my email that comes as a spreadsheet. When I try to open it, I get the message that I do not have Windows Office 2010 installed and it gives me options to purchase,etc. I have another spreadsheet installed on my computer and would prefer to use it but I don't know how to...
Software
Word Processor and Spreadsheet
I need to replace my word processor and spreadsheet. I have a free version of Word 2010 (Beta) now, but I won't be able to use it in 30 days. I don't use a word processor often and I don't need a lot of bells and whistles. I read somewhere of freeware called "Writer" and "Calc". If I were to...
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 15:36.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App