You don't need to use Format, the Text property will return the value in the cell as it's formatted.