How about the following formula if you don't want to use macros:
=IF(MID(A2,6,1)="",CONCATENATE(A2,0),A2)
or
=IF(MID(A2,6,1)="",A2&"0")
This formula assumes that there are not spaces in the cell text (for example, rewq q...would not work). Just put the formula in the adjacent cell. This could also be done pretty easily in a macro.
_________________
Hope this helps.
Kind regards, Al.
This message was edited by Al Chara on 2002-03-22 18:55
This message was edited by Al Chara on 2002-03-22 21:07