convert numbers stored as numbers to text

G

GemmaEiduks

How do I convert numbers stored as numbers to text quickly? I'm trying to add
in an extra 0 so that I can mail merge amounts e.g the cells (and formula
bar) say 2.1 and I need it to say 2.10. I've tried formatting the cells to
number, text, general e.t.c but it still stays the same in the formula bar
which means that's how it comes out in when it's been merged. I have about
1000 numbers I'll need to change by hand if I can't find out how this is
done.......please help!
 
N

N Harkawat

insert a new column and type this formula and fill it all the way down

=Text(a1,"0.00")

Now copy this new column and paste special -values over Column A

Your column A will now show the new values the way you wanted.(2.1 will show
as 2.10) (Assumed that the numbers are in column A.)
 
G

Gord Dibben

What does the formula bar say if you try to add more decimal points by
Format>Cells>Number?

Sounds to like your numbers are already text.

That's why you can't change 2.1 to 2.10

Format to General.

Copy an empty cell and paste special on the 2.1 cell.

Add more decimal places.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can the font and size of (all) citation numbers be altered? 1
Convert number to text as displayed 4
Convert numbers stored as text to numbers - Automatically - Macro 2
How to change font & size of (all) citation numbers? 7
Number stored as text 4
Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA) 0
Trouble with vlookup and numbers stored as text 3
Formula to add two spaces into a number stored as text 4

Top