I have prices listed in my exacel data sheet as follows: 1.20, 1.14, 1.30,
1.10, ect.
all of the numbers that end in a zero (1.20, 1.30, 1.10) only display a
value of 1.1 or 1.2 oe 1.3. The data shows up in excel as 1.10 and 1.20, but
the actual value is not that. I have tried to change the formatting but
nothing works. I am mail merging this excel data into word and my prices on
my mail merge are missing the end zero and we can't have that.
Any suggestions?