Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Tries 10 out of 10

0 views
Skip to first unread message

Frank Kabel

unread,
Apr 6, 2004, 11:05:15 AM4/6/04
to
Hi
either preced your entry with an apostrophe. e.g. '10/10
or pre-format the cell as 'Text'

--
Regards
Frank Kabel
Frankfurt, Germany

"Scott" <anon...@discussions.microsoft.com> schrieb im Newsbeitrag
news:74CB62AB-4E37-4BFB...@microsoft.com...
> What cell format would I use for 10/10 to appear as such, as opposed
to Oct-10 or 1 (10/10=1)
> thanks!

JE McGimpsey

unread,
Apr 6, 2004, 11:09:50 AM4/6/04
to
Preformat the cell as Text, or prefix the text with an apostrophe.

In article <74CB62AB-4E37-4BFB...@microsoft.com>,

Jason Morin

unread,
Apr 6, 2004, 11:41:18 AM4/6/04
to
Format the cell as text *prior* to entering data, or
simply precede each entry with an '.

HTH
Jason
Atlanta, GA

>-----Original Message-----
>What cell format would I use for 10/10 to appear as such,
as opposed to Oct-10 or 1 (10/10=1)
>thanks!

>.
>

anon...@discussions.microsoft.com

unread,
Apr 6, 2004, 12:35:23 PM4/6/04
to
Probably text format.

Lady Layla

unread,
Apr 6, 2004, 12:56:19 PM4/6/04
to
Format cells before hand
Copy info
paste special
value

"Scott" <anon...@discussions.microsoft.com> wrote in message
news:3D65C863-E09F-4D71...@microsoft.com...
: Thanks for the response...
: I am copying this data from the web and pasting into my spreadsheet. I cant
copy the data over and maintain the format. Is there any other way araound this
problem?
: Thanks again
: Scott


jim

unread,
Apr 7, 2004, 1:10:34 AM4/7/04
to
Maybe you can use the custom format : DD/MM.


"Scott" <anon...@discussions.microsoft.com> 写入邮件
news:74CB62AB-4E37-4BFB...@microsoft.com...

0 new messages