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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top