How to auto append word to only digit input data?

  • Thread starter Thread starter crapit
  • Start date Start date
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)?
 
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
 
Back
Top