convert number to text?

[sokevin]

hi i have "numbers" like this

530.224 which stands for "contract numbers" or "account codes"

i could go to each cell and edit put ' infront of the number. but is
there a quick way?


thanks

 

[Norman Harker]

Hi sokevin!

You could do it using a helper column and using the formula:

=TEXT(A1,"General")

One converted to text you can use
Copy
Edit > Paste Special > Values > OK

Maybe a better way. We normally get this problem in reverse.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[olark]

You could use the replace from the edit menu. If this works for you, i
is possible to record a macro to automate this

 

[Ken Wright]

With your data in say A1:H1000

in any empty cell ( Except Z1 :-> ), put =$Z$1 and copy that cell (Must be an
absolute reference)

Select A1:H1000 and do Edit / Paste Special / Add

Every entry will now be preceded with an = sign and appended with a +($K$1)

You can use Edit / Replace, replacing +($K$1) with nothing (leave field blank)
to get rid of all the +($K$1) which will leave every cell simply preceded with
an = sign which can be useful in itself, but to achieve your aim, simply do Edit
/ Replace again replacing the = with a '

 

[David McRitchie]

I'm not so sure of your question, and the solutions.
If the things don't work out then perhaps some more
information might be needed. Even if you got what you wanted
then please tell use what solution and perhaps a little more
information as to what you actually had.
530.200
530.210
530.224

Group B Numbers
530.2
530.31
530.224

What do you have now displayed, what do you have for
a format, what do you want. Exactly why do you ask the
question. Do you have numbers other than 3 digits before
and 3 digits after the decimal point.

What do you see if you use =ISTEXT(A1)
What do you see if you use =LEN(A1)

If you want to convert numbers to text as 000.000
Your helper column might have a formula like
=TEXT(A1,"000.000")

If you want to convert what you see as you now see it to
text you can use a macro using ".text" instead of ".value"

If you can simply put a single quote in front and hit enter,
you should be able to format the column as text

 

[Ken Wright]

LOL - Switch the K for a Z or vice versa.