Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to have a dot used as decimal symbol, regardless of locale
Hello,
I would like to print to a disk file decimal numbers stored in numerical cells, by using the dot as decimal symbol. As per my tests, Format(8.26,"0.00") will print either 8.26 or 8,26 depending on the locale. I need 8.26 to be printed regardless of the locale. Any suggestion? Thanks, Stefano Gatto Have no fear of perfection - you''ll never reach it (Salvador Dali) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to have a dot used as decimal symbol, regardless of locale
The following expression will give you the output that you asked for, as
text I think (I never have had to deal with international regional issues in my programming)... it assumes the value is assigned to the Number variable... Replace(Format(Number, "0.00"), Format$(0, "."), ".") -- Rick (MVP - Excel) "Stefano Gatto" wrote in message ... Hello, I would like to print to a disk file decimal numbers stored in numerical cells, by using the dot as decimal symbol. As per my tests, Format(8.26,"0.00") will print either 8.26 or 8,26 depending on the locale. I need 8.26 to be printed regardless of the locale. Any suggestion? Thanks, Stefano Gatto Have no fear of perfection - you''ll never reach it (Salvador Dali) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Decimal symbol not converting | Excel Discussion (Misc queries) | |||
Decimal Symbol | Excel Programming | |||
Decimal Symbol - point needed | Excel Discussion (Misc queries) | |||
Decimal Symbol | Excel Programming | |||
Regional Options and Decimal symbol from VBA | Excel Programming |