entiering numeric tags/identifiers

  • Thread starter Thread starter elizaG
  • Start date Start date
E

elizaG

I am entering numberic tags/identifiers such as 19.46, 19.2310. The zero is
dropped from 19.2310 and if set decimals zeros are added to 19.46. Can
format cells to text before entering but later analysis is not as easy (at
least for me). Are there other options
 
You can type in e.g. cell A1
'19.240
The ' wil turn it into text without having to format the cells, and it
will show correctly.

Then in a helper column you put in =value(a1)
That will return the value 19.24 for your analysis

Of course, the tag '19.240 will return the same value as '19.24

S
 
Back
Top