Micro Mart Forum / Microsoft Windows / Technical Forums / Spreadsheet query. / Latest Posts

RE: Spreadsheet query.

Mitch — Tue, 19 Aug 2008 16:40:36 GMT

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.

RE: Spreadsheet query.

-Wiz!- — Tue, 19 Aug 2008 11:06:24 GMT

It is Open Office I'm using. :) Prefer it to M$ Office too. :)

RE: Spreadsheet query.

bigdaddy — Tue, 19 Aug 2008 10:59:59 GMT

I've not used MS Office for some time. It works in Open Office so I assumed it might work in Xcell.:)

RE: Spreadsheet query.

-Wiz!- — Tue, 19 Aug 2008 10:53:07 GMT

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...:hehe:

RE: Spreadsheet query.

bigdaddy — Tue, 19 Aug 2008 10:45:06 GMT

Try entering the numbers as text.:)
Insert an apostrophe before the zero.:D

Spreadsheet query.

-Wiz!- — Tue, 19 Aug 2008 10:39:19 GMT

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! :)