|
|
|
Pentium
Group: Forum Members
Last Login: Today @ 19:59:03
Posts: 10,955,
Visits: 6,911
|
|
I have a spreadsheet containing phone numbers but the leading zero disappears. I have been playing around formatting the cells and had a google for the answer but I can't find it. Help! 
Intel e7200 @ 4.0GHz (4.32GHz SuperPi(e)) Lapped Asus P5E-VM (Vdroop pencil modded) 4Gb Patriot Pc6400 4-4-4-12 250Gb Samsung Spinpoint Sapphire ATI 3870/Akasa Vortexx Neo Enermax 600 Watt PSU Ubuntu/Win XP All in a Thermaltake Handbag... Or flying @ 4.21GHz in the Stacker. Try some MM Super Pi(e) here!
|
|
|
|
|
Pentium
Group: Forum Members
Last Login: Today @ 19:40:20
Posts: 3,164,
Visits: 9,626
|
|
Try entering the numbers as text.
Insert an apostrophe before the zero.
bigdaddy. Deputy leader of "The pedants' revolt". A founder member of "The GRUMPIES".
If you cannot laugh at yourself you may be missing the joke of the century.
The Janitor's mop.
XPSp2/Vista 64SP1/Ubuntu 8.10 64bit triple boot. Dave/MMF special, Asrock 775Dual-VSTA, Intel core duo E6600 S775 @stock, 2gig DDR2 Team Elite ram, 300 gig Maxtor SATA, Seagate 160 SATA,160 WD IDE, DVB-T media card, on board sound, Nvidia 8600 GTS. 19 inch AVidAV TFT. Ricoh DVD+RW, Pioneer DVD+/-RW,+ assorted other detritus.
|
|
|
|
|
Pentium
Group: Forum Members
Last Login: Today @ 19:59:03
Posts: 10,955,
Visits: 6,911
|
|
Wow! How easy was that. Thanks.
The reason I did not try was it lets you sample the effect and in the preview it just changed the cell content to a @ sign...
Intel e7200 @ 4.0GHz (4.32GHz SuperPi(e)) Lapped Asus P5E-VM (Vdroop pencil modded) 4Gb Patriot Pc6400 4-4-4-12 250Gb Samsung Spinpoint Sapphire ATI 3870/Akasa Vortexx Neo Enermax 600 Watt PSU Ubuntu/Win XP All in a Thermaltake Handbag... Or flying @ 4.21GHz in the Stacker. Try some MM Super Pi(e) here!
|
|
|
|
|
Pentium
Group: Forum Members
Last Login: Today @ 19:40:20
Posts: 3,164,
Visits: 9,626
|
|
I've not used MS Office for some time. It works in Open Office so I assumed it might work in Xcell.
bigdaddy. Deputy leader of "The pedants' revolt". A founder member of "The GRUMPIES".
If you cannot laugh at yourself you may be missing the joke of the century.
The Janitor's mop.
XPSp2/Vista 64SP1/Ubuntu 8.10 64bit triple boot. Dave/MMF special, Asrock 775Dual-VSTA, Intel core duo E6600 S775 @stock, 2gig DDR2 Team Elite ram, 300 gig Maxtor SATA, Seagate 160 SATA,160 WD IDE, DVB-T media card, on board sound, Nvidia 8600 GTS. 19 inch AVidAV TFT. Ricoh DVD+RW, Pioneer DVD+/-RW,+ assorted other detritus.
|
|
|
|
|
Pentium
Group: Forum Members
Last Login: Today @ 19:59:03
Posts: 10,955,
Visits: 6,911
|
|
It is Open Office I'm using. Prefer it to M$ Office too.
Intel e7200 @ 4.0GHz (4.32GHz SuperPi(e)) Lapped Asus P5E-VM (Vdroop pencil modded) 4Gb Patriot Pc6400 4-4-4-12 250Gb Samsung Spinpoint Sapphire ATI 3870/Akasa Vortexx Neo Enermax 600 Watt PSU Ubuntu/Win XP All in a Thermaltake Handbag... Or flying @ 4.21GHz in the Stacker. Try some MM Super Pi(e) here!
|
|
|
|
|
286
Group: Forum Members
Last Login: 15/11/2008 05:04:30
Posts: 472,
Visits: 12,677
|
|
Or you can right click the whole column, select "Format Cells" then the "Number" Tab and select "Text." That does the whole lot without the need for the old WYSIWYG ' before the number.
____________________________________________________________________________________
Desktop
Intel Core 2 Quad Q6600 @ 3.1ghz, Asus P5KPL Motherboard, 2 x 2GB DDR2 800mhz G-Skill RAM @ 5 - 5 - 5 - 15, Asus EAH3650 Graphics Card, 250GB SATA2 Hitachi Deskstar, 120GB IDE Maxtor, 36GB SATA WD Raptor, NEC Optiarc 20x DVD-RW, 425w Hiper PSU, Xerox XA7-19i 19” LCD Monitor, Microsoft SideWinder Mouse, 1 x BT HomeHub & 1 x BT HomeHub (Repeater). Vista Home Premium x64.
Lappy
HP Compaq - NX6325 Laptop, AMD Turion 64 x2 TL-52 @ 1.6ghz, 2 x 512MB DDR2 667mhz, ATI Radeon Express 1150 Graphics, 15” LCD Screen, XP Pro SP2.
& a Nokia E61 for sofa surfing!
____________________________________________________________________________________
|
|
|
|