Friday 19 August 2011

Force cells in Excel to use Text format rather than Number format - delphi

Force cells in Excel to use Text format rather than Number format - delphi

Obvious solution is obvious. Except for me.

I'm reading in test case values from MS Excel for an automation framework, so many values are coming across as floats, irrespective if I try and reformat them in my code. A simple prefix of a ' and everything is working. So simple yet this has eluded me for weeks.

1 comment:

  1. You only just found out about this? :P

    Why are you using excel? All the kool kats use Cucumber...

    ReplyDelete