I show the following message to users if cell c118 does not equal cell c119
(which is a linked cell from another file).
MsgBox ("You are using version " & Range("c118") & ". The current version of
this model is " & Range("c119") & ". Please download the current version
from the internet, and save it in place of this file. This file will
automatically shut down to prevent you from viewing inaccurate
The problem is the message box actually shows a "1" in place of
Range("c118") when I want "1.0" to be shown. I hace cell c118 formatted to
show "1.0", but the formatting doesn't apply itself when shown in the
Anyway around this?
Manager, Financial Systems
[log in to unmask]