Help with microsoft excel

  • Thread starter Thread starter beckvalleybooks
  • Start date Start date
B

beckvalleybooks

I want to insert g after data already entered in a column for every row in
that coloumn. I have over 4000 rows so this would take ages manually, is
there another way.

currently for example
0.100
want it to read
0.100g

please note all rows have different numbers.
 
Would a Custom Format of #,##0.00"g" work for you?

If you want the "g" hard-coded you must use a helper column and a formula

=A1 & "g" entered in B1

Double-click on the fill handle of B1

Select column B and copy.

Then paste special>Values>Ok>Esc

Delete column A


Gord Dibben MS Excel MVP
 
Fantastic , thankyou, worked completely.

Gord Dibben said:
Would a Custom Format of #,##0.00"g" work for you?

If you want the "g" hard-coded you must use a helper column and a formula

=A1 & "g" entered in B1

Double-click on the fill handle of B1

Select column B and copy.

Then paste special>Values>Ok>Esc

Delete column A


Gord Dibben MS Excel MVP
Click to expand...
 
Just curious.

Did you go with the custom format or the helper column with formulas?

I did not note that if you go with the formula method, the numbers are no
longer numbers but text.


Gord
 
Back
Top