B
Battista
I am currently trying to format an Excel spreadsheet in order to import it
into another program.
I am creating formulas using "&" to combine data from different coloumns
into one. However, one of the columns has numbers such as: 150.00, 150.01,
150.02, etc. Excel recognizes the decimal and the '01', '02' etc. however,
it doesn't recognize the ".00" when it combines it in the formula.
I've tried formating the column as text, and creating a formula that puts an
apostrophe in front (however, that doesn't recognize the".00" either).
There are thousands of lines, so I would REALLY like to avoid having to
input the ".00" manually.
Any help will be greatly appreciated.
into another program.
I am creating formulas using "&" to combine data from different coloumns
into one. However, one of the columns has numbers such as: 150.00, 150.01,
150.02, etc. Excel recognizes the decimal and the '01', '02' etc. however,
it doesn't recognize the ".00" when it combines it in the formula.
I've tried formating the column as text, and creating a formula that puts an
apostrophe in front (however, that doesn't recognize the".00" either).
There are thousands of lines, so I would REALLY like to avoid having to
input the ".00" manually.
Any help will be greatly appreciated.