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

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

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

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free 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

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

Spreadsheet-capture.png

Danny

Edit-Keiths got fast fingers tonight


My System SpecsSystem Spec
25 Aug 2011   #5

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 

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

windows 7 home premium 64bit
 
 

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

Microsoft Community Contributor Award Recipient

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

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

 Spreadsheet





Thread Tools



Similar help and support threads for2: Spreadsheet
Thread Forum
Works Spreadsheet Grid Lines Software
Problem with Excel Spreadsheet Microsoft Office
Solved A lot of ##### in my spreadsheet. Microsoft Office
Solved Populating Master Spreadsheet w/o Access Microsoft Office
A spreadsheet moron looking for help. Microsoft Office
Opening a spreadsheet Software
Word Processor and Spreadsheet 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 09:27 PM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33