[mso] Re: Excel Numbers
- From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Mon, 25 Nov 2002 20:08:07 -0500
Yep...there are various ways to do this....and some work in some
situations and others work in others. The Text to columns one was one
we kinda stumbled across in an Excel group I'm in...it kinda happened by
accident and now we all agree it's the easiest and fastest way to
convert numbers formatted as text back to numbers. I prefer this way
and the paste special multiply cuz they don't require adding another
column then having to get rid of it.
But, like I said, it's good to collect these cuz someday the one you've
been using forever won't work on some flukey spreadsheet and you will be
glad to know some of the other methods.
Linda
Publisher ~ ABC ~ All 'Bout Computers
Owner ~ Linda's Computer Stop
http://personal-computer-tutor.com
FREE MS Office eBook Tutorial
http://personal-computer-tutor.com/library.htm
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of Joe Trimarchi
Sent: Monday, November 25, 2002 7:53 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel Numbers
I believe you could also use the Value function. i.e. =Value(A1) would =
123456 if A1 contained '123456. You can copy that formula down a column
and
if necessary then copy that column and Past Special Values.
Regards,
Joe
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
