formatting an amount range

[cjd]

Hello,

I receive a data file with a column of amounts which do not include the decimal-for example the amount field will read 1050 which really means 10.50. Is there a way either while importing the field or after the import when it is in my spreadsheet, to insert the decimal in the proper place. I have tried to use the format-number feature but when I do I end up with 1050.00.

Any help is appreciated

Thanks
Carolyn

[Aladin Akyurek]

On 2002-05-02 12:02, cjd wrote:
Hello,

I receive a data file with a column of amounts which do not include the decimal-for example the amount field will read 1050 which really means 10.50. Is there a way either while importing the field or after the import when it is in my spreadsheet, to insert the decimal in the proper place. I have tried to use the format-number feature but when I do I end up with 1050.00.

Any help is appreciated

Thanks
Carolyn

Select an empty cell, type 100, and copy this cell. Select the target range with no decimals, activate Edit|Paste Special >Divide.

[cjd]

AA,

Thanks so much, gosh I never thought of that,thanks for that bit of common sense from the Netherlands.

Carolyn

[waderw]

or try:

dim newValue as string

newValue = mid(origValue,1,len(origValue -2)) & "." & right(origValue,2)

You might need to tinker with this a bit. It's hard to do it in my head.