Help with microsoft excel

[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.

 

[Gord Dibben]

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

 

[beckvalleybooks]

Fantastic , thankyou, worked completely.

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

 

[Gord Dibben]

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