R
RC
I would like to have the cell format set as text but display numbers
like $123,456.1234 while still having the data be just 123456.1234
I know that it would be easier to set the cell format to number, but I
want to manipulate the data and the number format messes that up. I
can start out with the cell format set at text, manipulate the data,
and -then- set the cell format to number to get the proper display,
which works fine until the user enters a number in that cell a second
time and now the format is set to number.
like $123,456.1234 while still having the data be just 123456.1234
I know that it would be easier to set the cell format to number, but I
want to manipulate the data and the number format messes that up. I
can start out with the cell format set at text, manipulate the data,
and -then- set the cell format to number to get the proper display,
which works fine until the user enters a number in that cell a second
time and now the format is set to number.