values are decimal

N

Noemi

Hi
I have an excel spreadsheet which is an extract from a text file.
When I convert text to columns any digit ending in a zero(s) has the zero(s)
dropped of however I need to the zero(s) remain because I will remove replace
the decimal with a comma as the digits are real thousands and not deicals.

Any idea how I can get the zero to stay and also be able to change to a 3
decimal figure which will keep the zero's when the decimal is replaced with
comma

ie

original text 858.70
text to column 858.7

what I want to end up with is 858,700

Thanks
Noemi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top