Houzz Logo Print
marie26_gw

Need help with excel, please

16 years ago

I'm working at home this weekend on a spreadsheet from work. I must have pressed something on the toolbar because the cells with numbers and prices now have tiny trinagles in the upper left corners. I was able to fix some of the numbers by converting text to numbers. Those that begin with zero, however, have deleted the zero and start with the number.

When I tried converting text to numbers in the cells with prices (no dollar signs), it took away the 2 decimal points and aligned everything to the left side instead of the right side.

How can I get these columns back to the original format?

I really need to finish this by Monday and appreciate your input.

Comments (4)