Friday, January 27, 2012

yogi_Custom Format A Numeric Cell With Some Text And The Cell Should Remain As Numeric

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
user Ewerton Emmanuel said:
Do you know how can I put a number and a text together considering the cell as NUMBER? For example I have some cells with a number such as 100 and I need to include the respective unity in it "t/h", i.e: 159 "t/h", but, the cell must be a number. In Excel I simply custom the cell, but here I really don't know.
Can you help me?
following is a solution to the problem