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                            www.energyefficientbuild.com
user Ewerton Emmanuel said:
Folks,
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?
Thanks.
----------------------------------
following is a solution to the problem