| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with microsoft excel
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with microsoft excel
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 specialValuesOkEsc Delete column A Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 09:45:01 -0700, beckvalleybooks wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with microsoft excel
Fantastic , thankyou, worked completely.
"Gord Dibben" wrote: 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 specialValuesOkEsc Delete column A Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 09:45:01 -0700, beckvalleybooks wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with microsoft excel
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 On Sat, 12 Sep 2009 10:05:01 -0700, beckvalleybooks wrote: Fantastic , thankyou, worked completely. "Gord Dibben" wrote: 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 specialValuesOkEsc Delete column A Gord Dibben MS Excel MVP On Sat, 12 Sep 2009 09:45:01 -0700, beckvalleybooks wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
| Relation Microsoft Access avec Microsoft Excel | Excel Discussion (Misc queries) | |||
| Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
| Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
| How do I import Microsoft Word files into Microsoft Excel? | New Users to Excel | |||
Linear Mode
