B
Bill Shih
Is there a way to have Excell 'spell out' a numeric entery
in a cell, for example: '1,234' into 'one thousand two
hundred thirty-four'? I am using a Chinese version, in
the format menu it gives a "Basic number format code"
[DBNum2] to spell out in Chinese. I need them in
English. English version user can highlight a cell, go to
Formats -- Cells -- Number -- Special and see if there is
a setting for that. Select the setting, then click Custom
in the Category menu on the left and the "code" will be
shown on the right in the "type" column.
Please help out. Thanks and thanks and many thanks.
in a cell, for example: '1,234' into 'one thousand two
hundred thirty-four'? I am using a Chinese version, in
the format menu it gives a "Basic number format code"
[DBNum2] to spell out in Chinese. I need them in
English. English version user can highlight a cell, go to
Formats -- Cells -- Number -- Special and see if there is
a setting for that. Select the setting, then click Custom
in the Category menu on the left and the "code" will be
shown on the right in the "type" column.
Please help out. Thanks and thanks and many thanks.