values are decimal
 

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

values are decimal
 

Hi Noemi,

Multiply your numbers by 1,000...


--
Hope that helps.

Vergel Adriano


"Noemi" wrote:

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

values are decimal
 

Hi Vergel

The most simplest solution and I did not think of it.
Thanks alot.
Noemi

"Vergel Adriano" wrote:

Hi Noemi,

Multiply your numbers by 1,000...


--
Hope that helps.

Vergel Adriano


"Noemi" wrote:

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