Is NumberString a function in previous Excel Version

[Emily]

Does NUMBERSTRING(1234567890,1) belongs to special feature during Excel developement OR the fuction in prievous version?

For example I am using Chinese Office XP, it display 1234567890 in Chinese Number format. There are two more option, 2 and 3 for NUMBERSTRING.

Also I can have the same effect as NUMBERSTRING(1234567890,1) use custom format, [DBNum1][$-404]G/General. Similar for the second but not for the third option.
This message was edited by Emily on 2002-09-22 21:17

 

[PaddyD]

emily,

as far as I know, numberstring() is provided for compatibility with earlier spreadsheet solutions - e.g. Lotus etc. So it's kept, but not documented (a bit like datedif() was until MS noticed that people were actually using it.

However, I did a search on google for it & came up with a number of hits from japanese / korean excel site, so I guess numberstring() is still proving useful to certain communities of excel users.

See if anything here helps;

http://groups.google.co.nz/groups?q=excel+numberstring&ie=UTF-8&oe=UTF-8&hl=en


& post back if you need...

Paddy

 

[Emily]

Hi Paddy

Actually I got the NumberString information from Japanese site during searching DBNum2.

Thanks

 

[PaddyD]

Hi Emily - do we still have a question to deal with (sorry, I can't tell!)

Paddy

 

[Emily]

I think NO after reading
http://groups.google.co.nz/groups?q...oe=UTF-8&selm=355523A4.590B@wanadoo.fr&rnum=8

Thanks a lot