Thread: BIG numbers
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rockbear Rockbear is offline
external usenet poster
 
Posts: 59
Default BIG numbers

AC 0810
Cumul
NOK

197,116,853
-74,281,084

122,835,769

-11,005,577
-10,993,675
0
0
-2,194,051
-333,394
-2,862,694
-1,066,468
-1,990,147
-5,927,555
-690,533
-1,213,536
-281,544
-1,098,468
-168,214
-1,919,818
-3,696,781
-820,149
These are a fewfof the numbers, the , (comma) is separator of the thousend.
The numbers are not text because it is punched in by economic dept.

All I get is a comma in the end of the number
--
Just a regular user


"Mike H" wrote:

How about a custom format of

#,##0,_)

Mike

"Rockbear" wrote:

Hi

I have a column H that has large numbers 11 515 100, 74 500 988, 79 560 533
etc
Is there a way to format the numbers in 1000?

11 515 100 in thousand it will be 11 515
74 500 988 in thousand it will be 74 501
79 560 533 in thousand it will be 79 561

Just format. the numbers, no formula


--
Just a regular user