Excel Cell-formatting

  • Thread starter Thread starter Tommy L.
  • Start date Start date
T

Tommy L.

Hi!

Does anyone know how to set own format in cell for numbers

have a number 4305605 and want 4.305
i.e numbers in tousand and a sign for tousand too or space like 4 305

I'v tried this #0(space);[Red] #0(space) and only get 4305

Plz Anyone, urgent

TIA

Tommy.
 
If that "dot" is a decimal point and you want 3 decimal places shown in
units of millions, then try this Custom Format...

#,##0.000,,

If, instead, that "dot" is your thousands separator and you want to display
your number in units of thousands, then try this Custom Format...

#,##0,

Rick
 
Tommy,

Try a custom number format with either

0,0,

or

0.0.

depending on what your thousands separator is.


HTH,
Bernie
MS Excel MVP
 
I don't have any international experience, so I'll assume Bernie is correct
in his posting... substitute your thousand separator for my comma and your
decimal point for my "dot" in the Custom Formats I posted.

Rick


Rick Rothstein (MVP - VB) said:
If that "dot" is a decimal point and you want 3 decimal places shown in
units of millions, then try this Custom Format...

#,##0.000,,

If, instead, that "dot" is your thousands separator and you want to
display your number in units of thousands, then try this Custom Format...

#,##0,

Rick


Tommy L. said:
Hi!

Does anyone know how to set own format in cell for numbers

have a number 4305605 and want 4.305
i.e numbers in tousand and a sign for tousand too or space like 4 305

I'v tried this #0(space);[Red] #0(space) and only get 4305

Plz Anyone, urgent

TIA

Tommy.
Click to expand...
Click to expand...
 
Back
Top