Format

system · November 17, 2009, 8:38pm

I have a formula like:

=Year([Case Dt (truncated)]) +"  WEEK  " + Week([Case Dt (truncated)])

It gives me result like this: 2,009 WEEK 40

I don’t want comma after 2 of 2,009. I want like 2009.
How can I change it ?

Developer_Designer (BOB member since 2009-08-09)

system · November 17, 2009, 8:44pm

[quote=“Developer_Designer”]Try something like

=FormatNumber(Year([Case Dt (truncated)]);"0000")

Nick Daniels (BOB member since 2002-08-15)