J
jdungan
I'm creating a spreadsheet of Test Cases using 1-1, 1-2, etc as my numbering
system.
The cells are all set as Text format, yet I started getting the following
error in Excel when I get to 1-32 and up:
"This cell contains a date string represented with only 2 digits for the year"
These cells are formatted to text so that they appear "as typed" so why is
it trying to convert it into a date?
I also can't use bulk replace to change "1-" to "2-"; when it does the
replace it converts ALL my test case numbers to (as far as I can tell) random
5 digit numbers; ex. 1-1 to 2-1 changes automatically to 39845, as well as
gives the following error:
"The number in this cell is formatted as text or is preceded by an
apostrophe".
This is extremely annoying and also means that I have to go through all the
duplicated test case sheet and change all the numbers manually.
Any suggestions?
Thanks.
system.
The cells are all set as Text format, yet I started getting the following
error in Excel when I get to 1-32 and up:
"This cell contains a date string represented with only 2 digits for the year"
These cells are formatted to text so that they appear "as typed" so why is
it trying to convert it into a date?
I also can't use bulk replace to change "1-" to "2-"; when it does the
replace it converts ALL my test case numbers to (as far as I can tell) random
5 digit numbers; ex. 1-1 to 2-1 changes automatically to 39845, as well as
gives the following error:
"The number in this cell is formatted as text or is preceded by an
apostrophe".
This is extremely annoying and also means that I have to go through all the
duplicated test case sheet and change all the numbers manually.
Any suggestions?
Thanks.