ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   decimal to comma (https://www.excelbanter.com/excel-discussion-misc-queries/122827-decimal-comma.html)

George P

decimal to comma
 
how do i convert a set of numbers represented in non-US format, n.nnn.nnn, to
US format n,nnn,nnn?

Dave O

decimal to comma
 
On the surface this seems like a routine formatting issue. Is there
more to the problem than that, perhaps a datafile that's hardcoded in
the non-US format?


Sloth

decimal to comma
 
Use Edit-Replace to replace all decimals with nothing (leave replace blank)
and hit replace all. Then change the format to add the commas in.

"George P" wrote:

how do i convert a set of numbers represented in non-US format, n.nnn.nnn, to
US format n,nnn,nnn?



All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com