How to auto append word to only digit input data?

C

crapit

E.g After entering number 84 in a cell, the the cell next to it right will
appear as 84.00cm (with the cm autoappend after the 2 decimal place)?
 
F

Frank Kabel

Hi

are you sure that you really want to append text after numbers and are
not trying to format your numbers. In your example you can go to
"Format - Cell" and enter the user defined format 0.00 "cm"

Frank
 
Top