Link to home
Start Free TrialLog in
Avatar of maroulator
maroulator

asked on

Function to Add a 1000 separator

To whom it may concern,

Is there a function that will allow me to add a 1000 separator; that is, I need to be able to a number, for example 1205 needs to be shown as 1,205.

I need a function, b/c I cannot use the 'format cells' that shows up after right-clicking.

Any advices?

-Maroulator
Avatar of IrogSinta
IrogSinta
Flag of United States of America image

If you're doing this in VBA, try this:
Format(RangeToFormat,"#,###)
Here's a function you could add to a module:
Public Function AddSeparator(rng As Range) As String
    AddSeparator = Format(rng, "#,###")

End Function

Open in new window

You would use it in a cell this way:
=AddSeparator(A1)
ASKER CERTIFIED SOLUTION
Avatar of Missus Miss_Sellaneus
Missus Miss_Sellaneus
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial