| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Net should be zero but it is not; decimal values aroung the 12 dec | Excel Worksheet Functions | |||
| Decimal Values | Excel Discussion (Misc queries) | |||
| Hiding certain decimal values | Excel Worksheet Functions | |||
| Finding Values With more than 2 decimal Places | Excel Discussion (Misc queries) | |||
| convert hex-values to decimal values | Excel Programming | |||
Linear Mode
