G
Guest
Hi,
I am importing some values into an Excel Spreadsheet from a .txt file
example imported values are:
47.80
1,089.90
I need to format these like so:
4780
108990
The problem I am having is that it Excel removes the zero from the end of
the amount leaving me with:
478 & 10899
Can anyone help me with this problem?
Thanks very much
Craig Ellis
I am importing some values into an Excel Spreadsheet from a .txt file
example imported values are:
47.80
1,089.90
I need to format these like so:
4780
108990
The problem I am having is that it Excel removes the zero from the end of
the amount leaving me with:
478 & 10899
Can anyone help me with this problem?
Thanks very much
Craig Ellis