Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
I have a column of numbers. I want to add "shercs" to them all w/o
having to type the whole column over. Is this possible One way is to use: Format cells Number Custom And put something like this in the "Type" #,##0.00 "shercs" This changes the display of the numbers, but the cells still are numeric. So you can use them in arithmetic formulas. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding text in formulas | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Adding a lot of text to MS Excel cells | Excel Discussion (Misc queries) | |||
Adding two text cells together | Excel Discussion (Misc queries) | |||
Adding Leading Zeros to Text | Excel Discussion (Misc queries) |