0

Translating Alphanumeric Field into Numeric Field in Excel

Jet Reports Historic Posts

November 24, 2009 14:39

None

Follow

In Navision Field Relation Number is an aplhanumeric field (CodeField). I'd like to format in a report this field into a numeric field, with 6 numbers.
For example: relation 10 should be reported as 000010, relation 1253 should be reported as 001253, relation 0133 should be 000133 in the report.
Changing the format of a Cell in Excel does not work. Can I use Format function in the Jet report function NF?

I have attached a report with a simple example and some printscreens

Best regards,
Saskia

• Example.xls

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts November 24, 2009 16:49

  Saskia,
  
  You can try
  =TEXT(NF($E9,"Nr."),"000000")

• 0
  
  Jet Reports Historic Posts November 25, 2009 08:22

  thnx!