i have many records that saved seconds into one field
the fields will record 4 range of seconds like:
[these kinds of record are only saved in one field]
BA
22.78 22.87 23.98
or
22.78 22.87 23.98 24.89
or
22.78 22.87 23.98 21.54 25.68
or
22.78 22.87 23.98 21.54 25.68 29.68
Usually I will use formula =LEFT(BA1,5) and =MID(BA1,7,5) , =MID(BA1,13,6)to records down to other fields like
BB BC BD
[22.78] [22.87] [23.98]
there is no any problem with these records but sometimes I mark a record like
24.2 23.43 23.22
Since these records are not the same as the upper records because these kinds of field do not accurate to 2 decimal places
If i still use formua left or mid , it will disappear few numbers like"
24.2 3.43 3.22
I have tried to use [Storage Format]> [custom] and added a new type #.00
#.00 could help me to add a 0 after the accurate to 1 decimal place like 24.20
but it could not use in a field which had used formula LEFT and MID
Only the field which did not use formula could use the custom #.00.
Now I have no idea to add a zero after the decimal place
Any one have some suggestions for me?
Thank you !
Bookmarks